Aggregating Custom Calculated Field in Reporting

[catherineh70969]

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

[TerryHy]

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

[catherineh70969]

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

[TerryHy]

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