Level 2 sprint 3 INV02 Country summary module

einas.ibrahim
Master Anaplanner/Community Boss

Re: Level 2 sprint 3 INV02 Country summary module

Hi @Younes 

So you are getting the right results now?

 

If you are getting the right results and you understand why you changed the formula this way, then my work here is done 😊
If you still have any questions, please let me know.

 

Just pay attention to the names suggested by the training, you have to use it exactly as it appears in the training.

Einas
"Give a Man a Fish, and You Feed Him for a Day. Teach a Man To Fish, and You Feed Him for a Lifetime"
r_barredo
Contributor

Re: Level 2 sprint 3 INV02 Country summary module

Hi, I saw the formula. And I have the same.

 

In Inv01, IF Ending Inventory < Safety Stock Target THEN 1 ELSE 0

In Inv02, 'INV01 Inventory Ordering'.Safety Stock Exception Count[SUM: 'SYS08 SKU Details'.Country Made In]

 

But when I reach 3.4.4, it makes me doubt if it is right. 

INV01 is actually All Regions, and Chocolates is 0 in Jan20

INV02 is All Regions, Chocolates but is 10 on Week2 FY20. 

 

Can someone help if this is right?