1 of 1 people found this helpful
What happens when you change your logic to:
if [Plan GRP] <> [Most Recent GRP] then 1 else 0 end ?
It might also be helpful to add a column for your fixed date calculation. You may find one is evaluating at the DAY level (rather than month), which would nullify all but one of your results.
Let us know what you find!
Did it work? Any change?