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

March 2026 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our March 2026 official release notes. There you'll find information on: Intelligence Anaplan CoModeler Anaplan Analyst Anaplan Agent Studio User Experience Data driven hierarchies with drag-and-drop Enable or disable comments Module-driven navigation actions…
February 2026 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our February 2026 official release notes. There you'll find information on: User Experience Board Insights Panel Management Reporting on mobile Custom action buttons on mobile Modeling experience Four digit calendar Forecaster Holiday calendars UX pages…