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

Help with Calculation(SUM)

Avatar

Level 7

I have a table with several columns and rows and a separate numeric field named TOTAL.

How for the numeric field(TOTAL) can calculate(Sum) the cells of a table(cells are numeric fields-Last column named: T1,T2, T3)

thanks

0 Replies

Avatar

Level 10

You can place the below syntax in the Calculcate event of the TOTAL field on your form.

Language : FormCalc

     SUM(T2,T3,T4); (OR)

     SUM(T2.rawValue,T3.rawValue,T4.rawValue);

Assuming your field names are T2, T3 and T4.. rawValue is not mandatory in FormCalc to get the field value.

Thanks

Srini