TExt mode for sum of a calculated field | Community
Skip to main content
T
TeriCh
Level 2
December 19, 2018
Question

TExt mode for sum of a calculated field

  • December 19, 2018
  • 3 replies
  • 994 views

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?

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    3 replies

    N
    NRYNR
    Level 10
    December 19, 2018
    Hi Teri, Is this a calculated column in the report, or is it a calculated field on a custom form? --Narayan
    T
    TeriChAuthor
    Level 2
    December 20, 2018
    Narayan it is a calculated field in the report not a custom field/form Teri Teri Chisholm Harvard Alumni Affairs and Development
    N
    NRYNR
    Level 10
    December 20, 2018

    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

    Terms & ConditionsAccessibility statement

    Loading footer...