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

how to autosum the amount column

Avatar

Level 1

I have been working on a form for hours and cannot figure out how to autosum one column in a table with three columns.  the first column contains a drop down list with test, the second is just a text field and the third is a numeric field.  I want the third column labeled amount to sum at the bottom row 4.

I currently have titles in the headers --Program Area(drop-down) is first column, Reason for Purchase (text field) is second column, and Amount is third column.  I have four rows with data and the last row is for my total of column 3 Amouts.  I have a header and footer.  Please help!

1 Reply

Avatar

Level 10

Write the code in the Calculate event of the Summary field in the row 4.

Use FormCalc as the language.

$.rawValue = Sum(Amount1.rawValue, Amount2.rawValue, Amount3.rawValue, Amount4.rawValue);

Change the field names to actual names in your form.

Thanks

Srini