Formula/Ratio Summary methods
Hi Colleagues, Master Anaplanners.
I've recently bumped in some complex calculations where I had to use different logic for different levels of hierarchy, most I've achieved through Ratio summary method, but there's one I cannot get it work. Hope I can get some ideas or out of the box thinking from you:
- NSV/KG is a calculated line item with ratio summary method - I need it's total category level in order to be used in another line item calculation (screenshot 2 for exemplification) - going to use a formula summary method.
- For this to be achieved, I cannot use lookup, but instead to calculate total category in another line item, that will apply to all skus.
- Yes, I am able to pull out total category with formula summary method, but then when I want to apply it to each sku I am forced to use lookup, therefore summary method cannot be formula for NSV category, hence my dilema. (down below I have used Average just to validate monthly calculation for subsequent flows).