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

September 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our September 2025 official release notes. The information below offers supplemental information to that post. Planning experience Improved Keyboard navigation across cards Across Boards, Insights, and Worksheets, tab navigation through toolbars in cards and…
Register for our October 29 platform release webinar!
Anaplan's next quarterly platform release webinar will be held October 29, 2025 at 8 a.m. Pacific Time. During this session, we will explore the latest features so you can optimize your Anaplan experience. Our expert-led session will equip you with a practical guide and live demonstrations to help you get the most out of…