NaN returns from sum of two RollUp fields

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.

+19

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}

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.

Sign up