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

Question regarding calculating a formula to add three tables of numbers

Avatar

Level 2

I need help with a form that I would like to show the Total of numbers from Table 6, 7 and 8.  I have put in codes for the Subtotals but the final total I can't seem to figure out.  Can someone help me with the coding to add subtotal 1, 2 and 3.

Thanks

7 Replies

Avatar

Level 10

I think part of your issue is not having unique names for each field. If you do not then you have to use occurance numbers on the form (that is what I did).

See my attachedrevised sample.

Paul

Avatar

Level 2

Thanks for a quick response but I noticed also that some of my cells in the table were not numeric so I changed it.  The Subtotal is not working.  I am getting an error.  Your formula was working but it did not include the last total of numbers. It should include tables 6, 7 and 8 totals.  Can you look at it again.  Thanks again!!

Avatar

Level 10

I modified the formulas .....I see how Table3 and Table 7 are used but it looks like Table8 is the total field....am I missing something?

Paul

Avatar

Level 2

Yes, table 8 is supposed to have the total of all tables from 6, 7 and 8 in each column but maybe it is the way I designed it that makes it confusing.

Avatar

Level 2

There are only two tables 6 and 7 that are being added.  Table 8 is not being added in with the Total.  Table 8 is where Total is listed.  If you put numbers in the last table 8, I would like for it to add those plus the two other tables above as one total.