Highlighted
Occasional Contributor

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!

 

2 REPLIES 2
Highlighted
Regular Contributor

Re: Level 2 Model Building Sprint 3 INV04

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
Highlighted
Regular Contributor

Re: Level 2 Model Building Sprint 3 INV04

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