Forum Discussion

tiffanynguyen's avatar
tiffanynguyen
Regular Visitor
9 years ago
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...
Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

tiffanynguyen

 

hi, use this:

 

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

 

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

This worked for me beautifully thank you

  • gabrielvigo's avatar
    gabrielvigo
    Helper I
    8 years ago

    Anonymous

     

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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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.