Formula

Markcol
Markcol
in Academy Discussions

Hi,

I don't understand it doesn't calculate margin/revenue properly.

 

Markcol_1-1654183934418.png

Thanks,

 

Mark

 

Tagged:

Comments

  • rob_marshall
    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
    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
    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
    Markcol
    Got it!.
    Thanks Rob.

    Mark

Categories