Hi there
I have a form that contains 17 rows. Each row has two numeric fields on them. I also have a total field. I would like the total field to multiply the two raw values in the numeric field of each row and to then add them all up. Is there an easier way to do this than scripting for each row calculation.
Many thanks
Darren
Views
Replies
Total Likes
FormCalc is very useful for this type of work. You can use an * as a wildcard when addresing fields and it will perform the operation on all fields that match. So for the total you can use Sum(rowTotal[*]) and it will add all instances of the fields called rowTotal.
Paul
Views
Replies
Total Likes
Hi Paul
Thanks for this but I do not have a row total, just the two numeric fields
in each row. My numeric fields also have slightly different names but all
begin with the same word so can I use the * for these?
Thanks
Darren
Views
Replies
Total Likes
No that will only work for occurance numbers ...they must all have the same name for that to work.
You will have no choice but to create a quite large formula naming each field individually.
Paul
Views
Replies
Total Likes
Thanks Paul
I was hoping that you were not going to say that!
Darren
Views
Replies
Total Likes
Views
Likes
Replies