Hi Guys,
I'm currently having issues with a formula. I'm not getting an error but it seems that the last part of my formula ( in red ) is not working. I'm getting the same data with it and without it. Any idea on what I can do differently?
IF [Action]="XFR" OR [Action]="REH"
AND NOT ({ FIXED [Emplid], [Empl Rcd]: MIN([Effdt])}=[Effdt] AND [Action]="PRO") THEN "Y" ELSE "N" END
I'm trying to remove certain duplicate data only when an employee has two rows on the same effective date. So I created the above formula to use as a filter to remove them. However as you see in the screenshot, it is not recognizing the second part of the formula and including all employees with "XFR" and "REH".
Any help is appreciated. Thank you!
