Skip to main content

Getting NaN in rollup field, stuck on how to fix it

  • May 29, 2019
  • 2 replies
  • 53 views
A
Forum|alt.badge.img+2

I have one table Evals where I have a true or false question that I want to count in another table called Eval Summary. In Evals, I created two formula fields that seem to be working fine:

IF({Would you attend a similar conference next year?}=“True”,1," ")

IF({Would you attend a similar conference next year?}=“False”,1," ")

I’ve linked the Evals to the Eval Summary table with linked field and created a rollup field linking to that table and formula field with SUM(values). But it’s just giving me NaN and I can’t really figure out why.

Any help is appreciated and thanks in advance!

2 replies

W
Forum|alt.badge.img+5
  • W_Vann_Hall
  • Inspiring
  • May 29, 2019

Get rid of the ‘else’ portion of that statement — that is, the ‘" "’ part the function reads

IF({Would you attend a similar conference next year?}="True",1)

Whenever an expression can be evaluated to either a number or a string, as your examples are, Airtable forces all responses to be text; in other words, you’re not summing 1 + 1, you’re summing '1' + '1'. Since you can’t add text + text, you get the Not a Number error…

A
A
Forum|alt.badge.img+2
  • Ambrose_Austin
  • Author
  • New Participant
  • May 29, 2019

Get rid of the ‘else’ portion of that statement — that is, the ‘" "’ part the function reads

IF({Would you attend a similar conference next year?}="True",1)

Whenever an expression can be evaluated to either a number or a string, as your examples are, Airtable forces all responses to be text; in other words, you’re not summing 1 + 1, you’re summing '1' + '1'. Since you can’t add text + text, you get the Not a Number error…


Thanks for your help! I really appreciate it.

Terms & ConditionsAccessibility statement