Forum Discussion
JofrainVisda
Advocate I
Advocate INaN 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...
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.
JofrainVisdaAdvocate I
Advocate IHello! 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
Community Champion
Community Championwhat 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 .