Level 1

0% to

Level 2

Tip /

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

View all

## How to do a partial sum of table rows in LiveCycle - Javascript

rfs87731640
Level 1

Likes

0 likes

Total Posts

1 post

0 solutions
View profile

rfs87731640
Level 1

Likes

0 likes

Total Posts

1 post

0 solutions
View profile
rfs87731640
Level 1

15-04-2016

I have 4 rows (and 3 columns) in a table. The last row is the total. I need to sum only the first two rows, excluding the last one. The problem is they are all calculated values from different tables, how do I do it? I am new to Adobe LiveCycle and Javascript.

This is what I currently have:

``var times = xfa.resolveNodes("Row2[*].Time"); this.rawValue = Calculate.SumRawValues(times);``

I am trying something like this:

``var times = xfa.resolveNodes("Row2[*].Time"); var timesFlushing = xfa.resolveNode("Row2[2].Time"); this.rawValue = Calculate.SumRawValues(times) - timesFlushing.value;``

or something like this:

``var times = xfa.resolveNodes("Row2[*].Time"); this.rawValue = Calculate.SumRawValues(times) - xfa.resolveNode("Row2[2].Time");``

or even this:

``this.rawValue = Row2.Time + xfa.resolveNode("Row2[1].Time")``

Clearly I am new to this and none of these work. Help please??? Comments?

#### Accepted Solutions (0)

MVP

Likes

397 likes

Total Posts

2,687 posts

492 solutions
View profile

MVP

Likes

397 likes

Total Posts

2,687 posts

492 solutions
``var times = xfa.resolveNodes("Row2[*].Time"),`    sum = 0;for (var i = 0, j = times.length; i < j; i += 1) {    if (i !== (j - 1) ) {          sum += times.item(i).rawValue;    }}this.rawValue = sum;`