INV02 - Safety Stock Flag Count line item formula - Level2 - Sprint3

Highlighted
New Contributor

INV02 - Safety Stock Flag Count line item formula - Level2 - Sprint3

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]

2 REPLIES 2
Highlighted
Master Anaplanner/Community Boss

Re: INV02 - Safety Stock Flag Count line item formula - Level2 - Sprint3

@ramas 

 

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

Highlighted
Occasional Contributor

Re: INV02 - Safety Stock Flag Count line item formula - Level2 - Sprint3

Thank you so much Misbah!

 

it really helped 🙂