Hello All,
I am having an issue calculating a value * another value in an calculated field from data in a repeating table.
What I want is for the form to calculate the List price * the qty field and in the Total list price calculated value field give me the total. The total list price is not apart of the repeating table.
It would be great if i could say for each line multiply the list price *qty and if there are 5 lines it would populate the total.
The data is coming from a secondary source.
What i would need is for the form to do the following :
2156*1+350*1+700*2 = 3906.00 Euros not 3206.00 as it does today.
In the calculated value field i added the below but it doesn't work it sums up the values but does not multiply it but the qty.....
Sum(List Price)*Qty
I also tried the below but in this case it only takes into account the first line.
List_Price * Qty
![]()
![]()
Your help is very much appreciated !!!!
Thank you in Advance
Rui