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

Calculating cells

Avatar

Level 2
I am trying to set up a cell that gives the total of a number of other cells. I know that in the object value you can choose calculated but I do not understand how to link to what cells I want to be the values. Thank you in advance for your help.



Tim Henderson
5 Replies

Avatar

Not applicable
try this replaceing my names of course with those that you are trying to add up. I have 3 thigns being added together and this is the calculation needed:



Sum(RegistrationCost,EstimatedHotelCost,EstimatedTravelCost)



Good luck

Avatar

Level 2
Thank you for this information. I left a vital piece of information out, these cells are in column in the table. and I am trying to add top to bottom. Thanks again.

Avatar

Level 10
Then using a formcalc expression you can use Sum(ColumnName[*].fieldname)

Avatar

Level 2
I was just coming back to say that I think I figured it out. I created my sum statement like this:

sum(ParcelOne.Acres,ParcelTwo.Acres,ParcelThree.Acres,ParcelFour.Acres,ParcelFive.Acres,ParcelSix.Acres,ParcelSeven.Acres)



And it did what I needed it to do.



Once again, thank you for your help.