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.

This topic has been closed for replies.

+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