Level 2 Model Building Sprint 3 INV04


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!


Best Answer

  • Kanishq17
    Answer ✓

    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,