Forum Discussion
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 reference of what I have tried so far
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.
6 Replies
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?
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.
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 .
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.
