L2 Sprint 3 Distribution center capacity module

Naaz09
Contributor

L2 Sprint 3 Distribution center capacity module

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!

 

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
JaredDolich
Moderator

Re: L2 Sprint 3 Distribution center capacity module

@Naaz09 

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

 


Jared Dolich

View solution in original post

2 REPLIES 2
JaredDolich
Moderator

Re: L2 Sprint 3 Distribution center capacity module

@Naaz09 

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

 


Jared Dolich
Naaz09
Contributor

Re: L2 Sprint 3 Distribution center capacity module

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