cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Sum with repeating section

Jump to solution

Hello,

I have two lists:

 In list 1 I have a column called Material, data is filled via lookup from another list (list 2). Depending on what "Material" is selected I have a "Price/Unit" (lookup("list2", "Material", parselookup(Material), "Price/Unit")). I have another column called "Quantity" defined as number. Depending on value entered in "Quantity" I calculate "Total Sum" using "Quantity*Price/unit".

All above is in a repeating section.

I need to have a "Total Amount" defined as currency that calculates all "Total Sum" in repeating section.

Been googling this one but was not able to find a solution, "Total Amount" is always "0"....

Any help is appreciated !

0 Kudos
Reply
2 Replies
Highlighted
Workflow Hero

Re: Sum with repeating section

Jump to solution
0 Kudos
Reply
Workflow Hero

Re: Sum with repeating section

Jump to solution

done it, thanks for the hint !

total Amount is calculated by sum(TotalSum), where TotalSums is chosen from "Named controls"

Reply