Forum Discussion

mengna's avatar
mengna
Frequent Visitor
7 years ago

Depleting Percentages

Hi All,

 

Sorry if this is a dumb question, but I'm not sure how to write a measure that calculates the % needed of an item if it appears in multiple locations. It should deplete from the % needed until 0%. Example below:

 

table

Need Help

4 Replies

  • Nathaniel_C's avatar
    Nathaniel_C
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Hi mengna 

    Not sure what your table is telling us? Where does the % of stock used up, come from?

    Thanks,

    Nathaniel

    • mengna's avatar
      mengna
      Frequent Visitor
      7 years ago

      That's the column I'm attempting to fix, I want it to be 100% if all the qty in a location needs to be depleted for fulfillment, and then have the next row(s) be calculated based off of how much is left to be fulfilled. 

       

      So 825 qty needed - (288 + 288) = 576, so we need 249 more qty.

      This is 37% of the 672 qty to fulfill the remaining. 

       

      Sorry for not using a simpler example, this is the current calculation I was actually dealing with.

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        7 years ago

        Hi,

        I still cannot understand what you want.  Someone else will help you.