Comparison Formula 1

[tkschief]

Hi,

How do I compare the same field in a group? For example, I have the following data (grouped by CASE_NUM):
CASE_NUM PID
JD-2010-00001 12345
JD-2010-00001 12345

JD-2010-00002 12346
JD-2010-00002 12347

I need to compare the PID's in each group and if the PID's are different in the case_num group, display that case_num group. If the PIDs are identical in the case_num group, do not display.

In my example, only the JD-2010-00002 records would display.

Thanks for your expertise!

Teresa

 

[MCuthill]

Teresa

You should be able to achieve this by a Group Selection Criteria based on DistinctCount({PID},{CASE_NUM})>1.

Hope this helps!

Mike
---------------------------------------------------------------
"To be alive is to revel in the moments, in the sunrise and the sunset, in the sudden and brief episodes of love and adventure,
in the hours of companionship. It is, most of all, to never be paralyzed by your fears of a future that no one can foretell."

 

[tkschief]

Thanks Mike - this worked perfectly!