Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!

Aggregating Custom Calculated Field in Reporting

Avatar

Level 6
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
3 Replies

Avatar

Level 8
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

Avatar

Level 6
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

Avatar

Level 8
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