AnsweredAssumed Answered

Sum with repeating section

Question asked by razvanb on Dec 18, 2018
Latest reply on Dec 18, 2018 by razvanb

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 !

Outcomes