Sprint 3 INV04

Options
Lkishko
Lkishko Member, ALL USERS, Community Member Posts: 5 Occasional Contributor
in Anaplan Community

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_1-1590167357438.png

Lkishko_2-1590167458383.png

Thanks for the help!

Tagged:

Comments

  • Lkishko
    Lkishko Member, ALL USERS, Community Member Posts: 5 Occasional Contributor

    @einas.ibrahim Thank you, that is helpful to think through and I was able to figure that part out actually, but I am still struggling with getting the correct output. It seems like I use the INV01 Module for Beginning Inventory and sum based on distribution center. 

    There might be another variable I am missing because later when I check the Distribution Center Summary Dashboard, my "Percentage Full" outcomes are wrong. 

     

    Lkishko_0-1590177933381.png

    Lkishko_1-1590178036194.png

    For Percentage full I am using Total Beginning Inventory / Distribution Center Capacity.

     

    Please let me know if you can see my mistakes here.

     

     

     

     

  • ifeldman
    ifeldman Member, ALL USERS, Partner, Certified Model Builder Posts: 5 Occasional Contributor

    @einas.ibrahim 

     

    Hi,

     

    I am stuck in making this formula as well. I have been using the INV01 as the beginning inventory, but when i do a SUM of the SYS08 Distribution Center module within the % Full line item, i get percentages that are over 100,000%. Any ideas or advice on how to change the formula so I get the right outputs?

  • Dpsullivan1
    Dpsullivan1 Member, ALL USERS Posts: 5 Occasional Contributor

    Hi @einas.ibrahim,

     

     I think I am running into the same issue here with my Total Beginning Inventory making my Percentage full over 100% capacity. See screenshot below.

    Dpsullivan1_0-1623189451835.png

     

    I feel like the issue is my Total Beginning Inventory in INV04 Distribution Center Capacity is taking all 4 weeks of January for example and summing the beginning inventories which I don't want. Like you said in your earlier posts, inventory goes up and down, but the beginning inventory in each week shouldn't be summed together and I feel like my INV04 is doing this because it's time setting in monthly.. I passed the level 2 sprint 3 exam and I'm pretty sure it said my formula was correct.. so I'm not sure why I can't get the correct values to show. Any ideas what I'm missing here? Appreciate the help, I've been stuck on this for some time.. 

  • Dpsullivan1
    Dpsullivan1 Member, ALL USERS Posts: 5 Occasional Contributor

    Hi @einas.ibrahim,

     

     Thank you so much for the help, it works now! 

Categories