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.

vanessafvg's avatar
vanessafvg
Community Champion
5 years ago

what is the calculated column code?   there is something underlying going on which is not visible in what you have posted so it would be very hard to tell you .  

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.