メインコンテンツまでスキップ

logoCorrectSize.png

Looks like this logo isn't being used anymore since we started using the new CSS to make our documentation look like our product UI.

Knowledge @ Adaptive Insights LLC, a Workday Company

Sum Arbitrary Level Rollups

This article includes suggestions and workarounds. Content may not be accurate for all use cases or represent best practices for the latest release.

Question

I have a report with a custom calculation that is summing 2 levels together. For my Gross Margin % calculation, the calculation is adding together the Gross Margin percentages rather than calculating on the aggregate. Is there a way to have the report calculate using the aggregate?

Answer

This can be done by using the levelrollup function instead of adding together the 2 levels in the Custom Calculation. This function can be used to perform arbitrary level rollup calculations in reports.

  • この記事は役に立ちましたか?