TExt mode for sum of a calculated field

[TeriCh]

I built an expense report that has a calculated field (Expense variance) - the report also groups my projects by Project - and I am able to sum at the group level for the planned amount and actual amount (native field) but not able to sum the calculated field - I am sure there is text mode that will allow me to do so - thoughts?

[NRYNR]

Hi Teri, Is this a calculated column in the report, or is it a calculated field on a custom form? --Narayan

[TeriCh]

Narayan it is a calculated field in the report not a custom field/form Teri Teri Chisholm Harvard Alumni Affairs and Development

[NRYNR]

Try switching to text mode and adding the "aggregator" lines, such as what is seen here in the Entry to Complete Date Variance example. However, your lines might look something like this:

aggregator.namekey=expensevariance

aggregator.valueexpression=SUB({plannedAmount},{actualAmount})

aggregator.function=SUM

aggregator.valueformat=HTML