Calculation problem

[SnookerDJ]

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

[Former Community Member]

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

[SnookerDJ]

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

[Former Community Member]

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

[SnookerDJ]

Thanks Paul

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

Darren