### Calculate and show total of each row and store whole total in a variable

Questions and discussion about using ProcessMaker: user interface, running cases & functionality

Moderators: ArturoRobles, ArturoRobles

### Calculate and show total of each row and store whole total in a variable#828162

By pawansaxena
#828162
I have a dynaform with a grid ( salesGrid variable ) in one task ( assigned to one user - employee ) that looks like :
Screenshot 2020-06-25 at 10.39.06 AM.png (18.16 KiB) Viewed 377 times
And in next task ( assigned to some other user ) i want to add one more column to the same grid which would show total of each row and also store all of the totals in some other variable to show at some other place.

How can i achieve this without using javascript.

Screenshot 2020-06-25 at 10.39.59 AM.png (16.43 KiB) Viewed 377 times

### Re: Calculate and show total of each row and store whole total in a variable#828163

By pawansaxena
#828163
solved it via following trigger :

\$lenGrid = count(@=salesGrid);
\$sumGrid = 0;

for (\$x = 1; \$x <= \$lenGrid; \$x++) {
\$tempSum = @%salesGrid[\$x]['mon'] + @%salesGrid[\$x]['tue']+ @%salesGrid[\$x]['wed'] + @%salesGrid[\$x]['thu'] + @%salesGrid[\$x]['fri'] + @%salesGrid[\$x]['sat'] + @%salesGrid[\$x]['sun'];
@%salesGrid[\$x]['tot'] = \$tempSum;
\$sumGrid += \$tempSum;
}
@%totalAmount = \$sumGrid;

### Re: Calculate and show total of each row and store whole total in a variable#828165

By reshmakavi
#828165
It is Very useful for me...
###### Error- when selfservice cases are more than 300

yes but still no luck. :(

###### Dynaform not dispaying when a new is started for a particular process

When a process is double click or highlighted to s[…]