Level 2 Training - Sprint 3 - INV01 Inventory Ordering Module

AashcaJ

Hello,

 

I am not sure what is wrong here: 

1. Beginning Inventory Formula: IF 'SYS01 Time Settings By Week'.'Not 1st Week of Timescale?' = TRUE THEN PREVIOUS (Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory[LOOKUP: 'SYS08 SKU Details'.Distribution Center]----Does this not look correct? Any help is greatly appreciated.

einas.ibrahim

Hello @AashcaJ 

 

Let me try to help you here. What is the error you are getting?

 

In theory, this formula should get you the correct answer but it has 2 unnecessary elements;

 

1. You don't need to say "IF 'SYS01 Time Settings By Week'.'Not 1st Week of Timescale?' = TRUE". You need a condition after the IF that resolves to True or False. Since Not 1st Week of Timescale? is a boolean then it resolves to True or False and it's enough to say IF Not 1st Week of Timescale? THEN ... ELSE
2. You also don't necessarily need the LOOKUP in this case because each SKU has a beginning inventory in just one location. So if you don't specify the location, the formula will sum up all the Beginning Inventory which is 13,000 + 0 + 0 + 0 ..... for example, which is 13,000.
   I like your way of thinking and it would be a more sustainable way just in case we had beginning Inventory in more than one location.. This is the same way I teach people to think about lookup, Look at every dimension in the source and make sure it either matches (like P3 SKU) or you need to explicitly send a lookup value ( like distribution Center).

In any case, the above won't cause the formula to give errors or produce the wrong values necessary. So back to my first question... what is the error you are getting?