I created a new field, Cost/Quantity, and the output is coming up at NaN.
I was able to see the Cost by year on a bar chart and quantity by year on a bar chart fine, but when I tried to doing Cost/Quantity on a bar chart, I am not getting anything due to NaN values. How do i fix this?
Solved! Go to Solution.
You're dividing by zero. That's impossible. That's why you're getting the error. You need to put in an if statement to return null when [D_Act_2doTermino] is 0.