FIND CHANGED RECORD

[MochaLatte]

How can I flag users who had a change in Class? I am grouping on USER ID Thanks!!!!

USER ID : 12345
NAME CLASS
JOKER Yellow
JOKER Yellow
JOKER Green

USER ID: 15687
NAME CLASS
BATMAN Blue
BATMAN Blue
BATMAN Blue

USER ID: 55555
NAME CLASS
BEAR RED
BEAR PURPLE
BEAR ORANGE

 

[IanWaterman]

Use previous() function

@Change
If USerID = Previous(userID) and Class <> Previous(class) then 1 else 0

Ian

 

[MochaLatte]

Thanks Ian! I've tried the formula and it worked flagging the differences. Now, I've been asked to select only the users whose class was changed
@Change >=1
For some reason the filter does not work when to try to do a group sum.
Any ideas!!!

 

[pmax9999]

You could do it by only displaying those groups where the distinct count of {class} for the User ID is greater than 1 (meaning it has changed). Add the following to the Group Selection:

[Code Group_Selection_Formula]
DistinctCount({table.class}, {table.user_id}) > 1
[/Code]


Pete