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

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…
Recording now available! October 29 platform release event
If you missed our October 29, 2025 platform release event, the recording is now available! In this webinar, we highlighted the most recent feature releases and how to take advantage of these in your environment. Our expert-led session demonstrated new features and innovations, provided a technical deep-dive and “how-to”,…