Aggregating Custom Calculated Field in Reporting | Adobe Higher Education
Skip to main content
Level 6
June 12, 2019
질문

Aggregating Custom Calculated Field in Reporting

  • June 12, 2019
  • 3 답변들
  • 745 조회
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 답변

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