1 of 1 people found this helpful
This may work:
// TA Difference
ZN( [Total Awareness (Last Week)] ) - ZN( [Total Awareness (This Week)] )
And then please remove [Week] blue pill from Columns.
That worked, thank you so much! Just so I understand what happened - what is ZN?
Thank you again!
2 of 2 people found this helpful
ZN returns an expression if it is not null, otherwise it returns zero. So if you've got a field with a bunch of null values in addition to actual values, wrapping an expression in ZN is a great way to make calculations work!
Makes sense, thanks for the explanation!