[TingTingXie]

Dear my helpers,

checked my screen in the attach,
I'm faced this problem this whole afternoon, i don't know how to solve it. please advise.

Basically i want this each expense category have a total sum first, then in the end i will know how much this employee spend money on meals, on travel and so on.
I know how to do the total sum.

But like my picture shows, if simply use "formula ="sum"", the practical meaning of the sum is wrong already.

I'm here waiting for your help, thanks in advance.

[victormlj]

Hi TingTingXie,

This is some what complicated but can be done. You can access the sum field of the grid with javascript. You can find is in the ProcessMaker wiki page.

http://wiki.processmaker.com/index.php/ ... JavaScript

Once you have access the field with:

getField("SYS_GRID_AGGREGATE_grid-name_field-name").value = "x";
getField("SYS_GRID_AGGREGATE_grid-name__field-name").innerHTML = "x";

you need to create a for loop so you can calculate the value you need it to show.

Good Luck,
Victor M Larrea