Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

NaN returns from sum of two RollUp fields

Topic Labels: Formulas
774 2
Showing results for 
Search instead for 
Did you mean: 

I have two fields (both are rollups - sum’s) that results in numbers:
Projection Views
Actual Views

I have set up another field with this formula:
SUM({Projected Views}-{Actual Channel})

But the formula returns a NaN. Can someone help me understand what the problem is here and how to resolve.

The rollup fields draw on two separate tables, if that makes any difference.

2 Replies 2

Is the field {Actual Channel} a number field? That could be causing your problem.

I don’t think you need to wrap your formula in the SUM() function, either. You can get the same result without it.

{Projected Views} - {Actual Channel}

Thank you. Rookie mistake, referencing the wrong filed. I was just blind to it. Thank you.