L2 Sprint 3 Distribution center capacity module

Shahenaz
Shahenaz
in Modeling

Hello 

Can someone please double check the formulas used for this module, its showing percentage for more than 100%. Is that normal? Please help me correct if there is any error in formula. Thank you!

 

Tagged:

Best Answer

  • JaredDolich
    JaredDolich
    Answer ✓

    @Shahenaz 

    Good call out. Simple solution. For percentages, whenever you aggregate up the hierarchy you need to consider what the right "summary" method should be. In this case I would recommend "ratio" not "sum".

    JaredDolich_0-1638659823594.png

     

Comments

  • Shahenaz
    Shahenaz
    Thank you for all your contributions and assistance with understanding logic and best practices. I have read through many of your posts to get my query answered. Grateful!!

Categories