1 of 1 people found this helpful
Turn your dimension to a datetime and try this:
If Year([Ash Savi]) = 2016 THEN "COMPLETE" ELSE "INCOMPLETE" END
The calculation you wrote seems like it would return all INCOMPLETE values. Are you sure it's returning "COMPLETE"?
Thank you so much. That worked like a charm!
You are right. I transposed my write up.