Formula for calculating grand totals on three columns

[AssetRecovery]

I have a report that shows three columns that have data in them. I need to take those numbers from each column and total then at the bottom of the column. I need an example formula that could do this or should this be handled in another method.

 

[lbass]

If you don't have duplicate data, just select a column, right click, and choose insert summary or grand total, and then choose the type of summary you would like.

-LB

 

[mbarron]

If you need to add all three columns, use lbass's method above and then create a formula to add the three summaries together.

Your formula will look something like this if its a group total:
Sum ({data.field1}, {grouped.upon.field})+Sum ({data.field2}, {grouped.upon.field})+Sum ({data.field3}, {grouped.upon.field})

or if it's a grand total:
Sum({data.field1})+ Sum({data.field2})+Sum({data.field3})

Mike