Comparing current row to previous row

[scotton]

I am using the employees job history table and trying to compare the current process level (aka pl) to the previous pl and have only the employees most current row displayed if there is a different in pl's.

I am using the Next function as a formula field to identify the previous pl and that works great. I created another formula field to compare the two and it flags the rows that are different with True. How can I have it only display the row that has a different pl from it's previous pl row?

 

[lbass]

Please show the content of the formulas you are using.

-LB