Hi,
Can you please verify my formula for INV02-Safety Stock Flag Count line item and suggest me what I am missing
'INV01 Inventory Ordering'.Safety Stock exception count[SUM: 'SYS08 SKU Details'.Product Family, SUM: 'SYS08 SKU Details'.Country Made In]
'INV01 Inventory Ordering'.Safety Stock exception count[SUM: 'SYS08 SKU Details'.Country Made In, SUM: 'SYS08 SKU Details'.Product Family]
Solved! Go to Solution.
You have applied one too many SUMs in the formula. If you look at the dimensionality of your modules
Source Module - P3 SKU & Time
Target Module - G2 Country, P1 Product Family & Time
Since P1 Product Family is Grand Parent (Parent of Parent) of P3 SKU and is part of the hierarchy anaplan will automatically aggregate the numbers from P3 to P1. Hence there is no need to use SUM on P1 Product Family. You can keep the other SUM on G2 Country as this dimension is not available in Source Module. So your formula should be like
'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Country Made In]
Hope that helps
Misbah
Thank you so much Misbah!
it really helped 🙂