Forum Discussion

GrahamR99's avatar
GrahamR99
Icon for Resolver I rankResolver I
8 years ago
Solved

Sales QTY divided by Booked In as stock Movement

Hello

I'm tring to create a calculated column of Sales QTY divided by Booked in QTY to give me a Stock Movement percentage.

 

I have tried this;

Stock Movement = Append1[SQTY] / Append1[book_qty]

 

But it come up with Infinity.

 

I have a screen shot;

 

What is the DAX to get the correct calculation?

 

Regards

 

GrahamR99

  

Need Help
  • Interkoubess's avatar
    Interkoubess
    8 years ago

    Hi GrahamR99,

     

    Please use this formula ( use calculate rather than the column) and let us know if it does not work:

    Stock Movement = Divide(Calculate(Append1[SQTY]),calculate(Append1[book_qty]),0)

    Thx

     

    Ninter

  • GrahamR99's avatar
    GrahamR99
    8 years ago

    Hello Ninter

    Your formula did not work sorry;

     

    I had to change it to;

    Divide(Calculate(Sum(Append1[SQTY])),calculate(Sum(Append1[book_qty])),0)

     

    Thank you for your help.

     

    Regards

     

    GrahamR99

2 Replies

  • Interkoubess's avatar
    Interkoubess
    Icon for Solution Sage rankSolution Sage
    8 years ago

    Hi GrahamR99,

     

    Please use this formula ( use calculate rather than the column) and let us know if it does not work:

    Stock Movement = Divide(Calculate(Append1[SQTY]),calculate(Append1[book_qty]),0)

    Thx

     

    Ninter

    • GrahamR99's avatar
      GrahamR99
      Icon for Resolver I rankResolver I
      8 years ago

      Hello Ninter

      Your formula did not work sorry;

       

      I had to change it to;

      Divide(Calculate(Sum(Append1[SQTY])),calculate(Sum(Append1[book_qty])),0)

       

      Thank you for your help.

       

      Regards

       

      GrahamR99