Aggregating Custom Calculated Field in Reporting | Community
Skip to main content
Level 6
June 12, 2019
Question

Aggregating Custom Calculated Field in Reporting

  • June 12, 2019
  • 3 replies
  • 745 views
We use a custom calculated field to show the difference between planned and actual expenses. This rolls into reporting for each expense just fine, but I'm tripping over myself on the aggregation. The text mode I've set up for this on the View for this custom calculated field is: aggregator.displayformat=currencyStringCurrency aggregator.function=SUM aggregator.valuefield=PDS | Expense Difference aggregator.valueformat=doubleAsDouble displayname=Expense Difference linkedname=direct namekey=PDS | Expense Difference querysort=DE:PDS | Expense Difference textmode=true valuefield=PDS | Expense Difference valueformat=customNumberAsCurrencyStringCurrency Any ideas? What am I missing? Catherine Hayes Manager, Business Analytics and Program Operations The Channel Company Westborough MA
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

3 replies

Level 8
June 12, 2019
Hi Catherine, looking at this quickly, I think perhaps you are missing the DE: in this line: aggregator.valuefield=PDS | Expense Difference aggregator.valuefield= DE: PDS | Expense Difference Hopefully, this was it. Terry Hynd EBSCO Information Services
Level 6
June 12, 2019
HI @Terry Hynd I thought so too, but no luck. Thanks, though! Catherine Hayes Manager, Business Analytics and Program Operations The Channel Company Westborough MA
Level 8
June 12, 2019
How about this? aggregator.displayformat=currencyStringCurrency aggregator.function=SUM aggregator.namekey=PDS | Expense Difference aggregator.valuefield=DE:PDS | Expense Difference aggregator.valueformat=doubleAsDouble displayname=Expense Difference linkedname=direct namekey=PDS | Expense Difference querysort=PDS | Expense Difference textmode=true valuefield=PDS | Expense Difference valueformat=customNumberAsCurrencyStringCurrency