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.
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.