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

[AEM Gems Webinar] Accelerating Experience Manager as a Cloud Service development with Rapid Development Environments

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