My Stock ratio expression return null

[Paulyeo11]

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

[v-janeyg-msft · Accepted solution]

Hi, @Paulyeo11 

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.

[Paulyeo11]

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