Formula
Options
Hi,
I don't understand it doesn't calculate margin/revenue properly.
Thanks,
Mark
Tagged:
0
Comments

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
1 
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?0 
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
1 
Got it!.
Thanks Rob.
Mark0