I'm trying to use the previous function to check to see if I have duplicate departments in my detail.
my formula is : if dept = previous(dept) then 1 else 0
I though that by using the previous formula, I would get whats listed in the expect result.
Can you guys help me get the expected result by either using the previous command or something else.
This is what I currently have:
Dept DupCheck Expected Result
01000 1 0
01000 1 1
01200 1 0
01200 1 1