Help

NaN returns from sum of two RollUp fields

Topic Labels: Formulas
1143 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Brett_Snelgrove
6 - Interface Innovator
6 - Interface Innovator

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
AlliAlosa
10 - Mercury
10 - Mercury

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.