Forum Discussion
Solved
NaN Error
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 Co...
Vvelardenope, turns out this is a custom column in the query editor. No DIVIDE there.
MarcelBeug
Community Champion
Community ChampionTypically you get NaN when dividing 0 by 0.
So adjust your formula something like if Quantity = 0 then 0 else Cost / Quantity.
How do i get rid of this? Would I be able to replace it with 0 or null?
- Vvelarde
Vvelardenope, turns out this is a custom column in the query editor. No DIVIDE there.
- Vvelarde
Anonymous Thanks. Yes, Divide don't apply in query Editor.
This worked for me beautifully thank you
- gabrielvigo
Helper I
Anonymous
How did you write the formula in the custom column?
I have the same issue.
super!!!! Thanks Sir!!!!
