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

August 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our August 2025 official release notes. The information below offers supplemental information to that post. Planning experience Multi-browser tab syncing When changing context or data on a UX page, you can now view real-time data updates across up to five…
July 2025 platform releases and what’s next
Check out the latest Anaplan feature updates and enhancements in our July 2025 official release notes. The information below offers supplemental information to that post. Planning experience External URL navigation button Page builders can configure navigation action buttons to link to external URLs, including non-Anaplan…