Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Count If Values in Dynamic Nested Tables

Avatar

Avatar
Validate 1
Level 1
redbaron07
Level 1

Like

1 like

Total Posts

11 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
redbaron07
Level 1

Like

1 like

Total Posts

11 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
redbaron07
Level 1

03-08-2016

Have an expanding table nested in another expanding table.  Attempting to count the number of times:

The value in the "DateTimeField2" field in the last row of the nested table on the previous row of the main table is equal to

The value in the "DateTimeField2" field in the first row of the nested table on the next row of the main table.

This one is driving me nuts, any help would be greatly appreciated.  Here is what I have so far.  Thanks again!

var sumDCD = 0;

var dcd = this.resolveNodes("RowX[*].Subform2[*].Table1[*]");

//app.alert(dcd.length);

for (var i = 1; i < dcd.length; i++)

{

var row = this.resolveNodes("RowX[*].Subform2[*].resolvenode[" + (Table1[i-1]._Row1.count - 1) + "]");

if(dcd.item(i).DateTimeField2.Row1[row].rawValue = dcd.item(i-1).Row1[0].DateTimeField2.rawValue)

{

sumDCD += (dcd.item(i).Row1.DateTimeField2.length);

}

}

sumDCD

Accepted Solutions (0)

Answers (1)

Answers (1)

Avatar

Avatar
Validate 1
Level 1
redbaron07
Level 1

Like

1 like

Total Posts

11 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
redbaron07
Level 1

Like

1 like

Total Posts

11 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
redbaron07
Level 1

04-08-2016

Anyone have any thoughts?  Still have not been able to get this working despite significant tinkering.