Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Calculation problem

Avatar

Level 4

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

4 Replies

Avatar

Level 10

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

Avatar

Level 4

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

Avatar

Level 10

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

Avatar

Level 4

Thanks Paul

I was hoping that you were not going to say that!

Darren