Sprint 3 - 3.5.4.2 Create Distribution Center Capacity Module

Hi,

 

In activity 3.5.4.2 Create Distribution Center Capacity Module formula I gave for Percentage Full is Total Beginning Inventory / Distribution center capacity. But result is greater than 100%. I'm attaching the screenshot. Please help. 

Thank you very much

Tagged:

Comments

  • @akssaju 

     

    Total Beginning Inventory value doesn't seem to be right. For New York it should be 51762 in Jan 20.

     

    Misbah

  • This is my equation for Total Beginning Inventory 'INV01 Inventory Ordering'.Beginning Inventory[SUM: 'SYS08 SKU Details'.Supplied By] I don't know what went wrong. Can you please help. Thank You very much.

     

  • Hello,

     

    Did you get it right?

     

    I came up with the same formula too, but its not working. Please help

     

    Thank you,

    Sneha.

  • Hello,

     

    I have put this formula - 'INV01 Inventory Ordering'.Beginning Inventory[SUM: 'SYS08 SKU Details'.Supplied By]

     

    I am getting 197,594 in Jan2020 - New York

     

    Please help

     

    Thank you,

    Sneha.

  • Hello Community members

     

    I think this formula is correct 'INV01 Inventory Ordering'.Beginning Inventory[SUM: 'SYS08 SKU Details'.Supplied By] 

  • What's wrong with the values2022-10-29 (10).png2022-10-29 (9).png

  • @kalakantisneha
    , I don't get 51,762 for NY in Jan 2020. This is what I got. See if that's what you got.

  • That upgrade I have been repeated!