Level 2 sprint 3 Build Distribution Summary Dashboard

Highlighted
Contributor

Re: Level 2 sprint 3 Build Distribution Summary Dashboard

Hi Swapnil

 

Thank you for direction, I tried below...

 

IF NOT 'SYS01 Time Settings By Week'.First Week of Timescale? THEN 'INV01 Inventory Ordering'.Ending Inventory[LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: 'SYS08 SKU Details'.Distribution Center'] ELSE 'DAT01 Beginning Inventory'.Beginning Inventory gave an error msg like below.

 

Augustus_2-1601854676448.png

 

 

However I need to bring...Monthly Ending Inventory (in other words Monthly Beginning inventory Feb 20, sku1 + sku2 + sku 3 to calculate the fill rate for Feb 20, based on the location capacity, refer target module screenshot)

 

with previous function I get the total All product i.e 115,941 total duplicated to each sku, any method to extend the formula? 

my attempts.

IF NOT 'SYS01 Time Settings By Week'.First Week of Timescale? THEN PREVIOUS('INV01 Inventory Ordering'.Ending Inventory) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory

 

IF NOT 'SYS01 Time Settings By Week'.First Week of Timescale? THEN 'INV01 Inventory Ordering'.Beginning [LOOKUP: 'SYS08 SKU Details'.Product, LOOKUP: 'SYS08 SKU Details'.Distribution Center'] Inventory ELSE 'DAT01 Beginning Inventory'.Beginning Inventory

 

IF NOT 'SYS01 Time Settings By Week'.First Week of Timescale? THEN 'INV01 Inventory Ordering'.Beginning [SUM: 'SYS08 SKU Details'.Product, SUM: 'SYS08 SKU Details'.Distribution Center'] Inventory ELSE 'DAT01 Beginning Inventory'.Beginning Inventory

 

Augustus_0-1601854326825.png

 

Augustus_1-1601854568486.png

 

 

Highlighted
Contributor

Re: Level 2 sprint 3 Build Distribution Summary Dashboard

You have already created the formula for Beginning Inventory line item in INV01 module.

You don't need to rewrite that formula in T.B  Inventory line item INV04 module.

try with this : 

INV01.BEGINNING INVETORY[SUM: ......]

Highlighted
Contributor

Re: Level 2 sprint 3 Build Distribution Summary Dashboard

Hi Swapnil

 

Appreciate the direction, Thank you.