Expand my Community achievements bar.

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
0 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

Not applicable
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.
page footer