L2 Sprint 3 Distribution center capacity module


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!



Best 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".




  • 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!!