Mileage rate in a repeating table

[matdcar1984]

Hi,

Im trying to find a calculation to times the mileage rate by the number of
miles in a repeating table to give me a total, I have tried
sum(rate)*sum(miles) but when i goto the second line and put in the rate it
uses the previous amount of miles and adds it to the subtotal. Then when I
put in the miles at also adds that amount.

 

[Franck Dauché]

Hi,

You can search in this forum for a post untitled: "getting sum of product of
all the fields in repeating section" dated 10/19.

Regards,

Franck Dauché

 

[matdcar1984]

Hi,

Thanks for replying so quickly and I think I know what I have to do now,
although my java scripting is pretty much non existant im afraid. Do I need
to create a loop to total the first rate * number of miles and then when i
insert a new line plus it to the subtotal and do it again

 

[matdcar1984]

Hi,

This works well when you have a single amount to total, but when you have a
calculation like mileage rate times number of miles to repeatedly total it
does not, the number of miles changes as does the rate.

Hope you can help with this as my javascripting is pretty bad

thanks