Forum Discussion

JofrainVisda's avatar
JofrainVisda
Advocate I
5 years ago
Solved

NaN Error when dividing

Hi friends, I know this is not a new issue, but I have tried all the possible solutions that I have seen here and nothing worked. Can someone help me on this? Check my screenshots for the referenc...
Tips and Tricks
  • JofrainVisda's avatar
    JofrainVisda
    5 years ago

    Thank you for all the suggestions guys. I have solved the issue by using the quick measure. It generated this formula
    Productivity Ratio = Divide(Sum([Volume2]),Sum([Headcount2])) which I haven't tried. The SUM function is like converting them into a measure from being a column.

JofrainVisda's avatar
JofrainVisda
Advocate I
5 years ago

The Volume and Headcount columns have complicated logic actually. There are combinations of multiple columns. Here is Volume's code

.
And here is the productivity2

 

v-xiaotang's avatar
v-xiaotang
Community Support
5 years ago

Hi JofrainVisda 

Productivity Ratio = Divide([Volume2],[Productivity2])

try this.

 

 

Best Regards,

Community Support Team _Tang

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