Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

My Stock ratio expression return null

Hi All

 
My 1st measure :-
Amt_On Hand = SUMX(INVC, INVC[UNIT_COST]*INVC[QTY_On Hand])
 
My 2nd measure :-
AVE_AMT = SUMX(INVC, INVC[UNIT_COST]*INVC[AVE_QTY_])
 
RATIO=
DIVIDE(
SUMX(INVC, INVC[UNIT_COST]*INVC[QTY_On Hand]),  SUMX(INVC, INVC[UNIT_COST]*INVC[AVE_QTY_]))
 
Hope some one can share with me where go wrong ?
 Paul
  • Hi, Anonymous 

     

    It’s my pleasure to answer for you.

    The measure has no syntax errors.Is the result of the 1st,2nd measure what you want?Could you share some sample data and your desired result?So we can help you soon.

    According to your description,I think maybe the value is too small and displayed as an integer, you can change the format in the measure tools.

    Like this:

    If it doesn’t solve your problem, please feel free to ask me.

     

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Community Support

    Hi, Anonymous 

     

    It’s my pleasure to answer for you.

    The measure has no syntax errors.Is the result of the 1st,2nd measure what you want?Could you share some sample data and your desired result?So we can help you soon.

    According to your description,I think maybe the value is too small and displayed as an integer, you can change the format in the measure tools.

    Like this:

    If it doesn’t solve your problem, please feel free to ask me.

     

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi Sir

      i have get it solve already

      i just divide the 2 of them and it work 

      My mistake is I try divide using expression is wrong