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

[ramas]

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]

[Misbah · Accepted solution]

@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

[mmounika]

Thank you so much Misbah!

it really helped 🙂

[JosephA]

Do you have a screen print after you got the right formula?