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 !