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.

 

Lkishko_0-1590164533947.png

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,

    Kanishq17_0-1590409694589.png

     

     

Answers