Formula

Markcol

Hi,

I don't understand it doesn't calculate margin/revenue properly.

Thanks,

Mark

Comments

rob_marshall

@Markcol

Change the summary setting in the blueprint to be Formula for Margin %. Currently, it is summing the data and you are looking at an aggregated level (Americas).

Rob

Markcol

Yes, You're right and it works. Many thanks!!!
Quick question : Margin has a formula, too but I don't need to change the summary setting to be Formula for Margin. It works properly with Sum in the Summary setting. Why?

rob_marshall

@Markcol

Because Margin % is division and needs to evaluate the numbers at every level instead of at the lowest level and then summing up the hierarchy.

Rob

Markcol

Got it!.
Thanks Rob.

Mark

Quick Links

Recent release news

November 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our November 2025 official release notes. The information below offers supplemental information to that post. Intelligence Anaplan Forecaster: General enhancements Anaplan Forecaster now supports list subsets for the item ID list and custom time, list format…
October 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our October 2025 official release notes. The information below offers supplemental information to that post. Planning experience Combined Grids This new capability gives page builders the ability to combine multiple modules into a single, unified grid on a UX…