NaN Error when dividing

[JofrainVisda]

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 reference of what I have tried so far

[JofrainVisda · Accepted solution]

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]

its difficult to understand what is going on there without seeing all the underlying data.

divide would be the correct function to use in my opinion, what are you trying to do?   can you provide some sample data?   is volume2 a column or a aggregation?

[JofrainVisda]

Hello! Well as you can see there are numbers for Volume and Headcount columns. These figures are correct already. But when I divide them, I get the NaN or infinity error. Both of them are calculated columns. Using Divide function gives me incorrect result. It should give me 280 and not 774K.

[vanessafvg]

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]

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]

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.