NaN Error

[tiffanynguyen]

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?

Thanks

[MarcelBeug]

Typically you get NaN when dividing 0 by 0.

So adjust your formula something like if Quantity = 0 then 0 else Cost / Quantity.

[SihamHabash1990]

it is not working for me 

---

@MarcelBeug wrote:

Typically you get NaN when dividing 0 by 0.

So adjust your formula something like if Quantity = 0 then 0 else Cost / Quantity.

---

[Anonymous]

THANK YOU! That was so easy to fix. Thank you!

[tiffanynguyen]

How do i get rid of this? Would I be able to replace it with 0 or null?

[Vvelarde]

@tiffanynguyen

hi, use this:

Measure=Divide([Cost],[Quantity],0)

[Mownaradha]

super!!!! Thanks Sir!!!!

[Anonymous]

This worked for me beautifully thank you

[gabrielvigo]

@Anonymous

How did you write the formula in the custom column?
I have the same issue.

[KHorseman]

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.

[KHorseman · Accepted solution]

@Vvelardenope, turns out this is a custom column in the query editor. No DIVIDE there.

[Vvelarde]

@KHorseman Thanks. Yes, Divide don't apply in query Editor.