Level 2 Model Building Sprint 3 INV04

Lkishko

Hi, Could someone please help me with the module below?

 

I am struggling with the Percentage Full result that I get and I think it is because I am doing something wrong in the Beginning Inventory line.

I am pulling BI from DAT01 which gives a straight line across all months. What am I doing wrong?

I also could use a suggestion for the conditional formatting of the % Full line.

 

Thanks for the help!

 

Kanishq17

hi @Lkishko 

 

for the beginning inventory, you need to pull values from the Inv01 module beginning inventory line item and sum by distribution centre which is for each SKU, so the beginning inventory will be vary by months

 

for conditional formatting,

 

 

L.A.Foster

You might want to look at the Academy & Training forums - and move your post there https://community.anaplan.com/t5/Academy-Training/bd-p/academyCourses