Excluding multiple values into one string

[peewan]

ello Friends.


I would like to get excluding result for All line of Claim# have "80053' Pro Code.
For example:

CL_N  Claim_Nbr    Proc_Code   line#
52     12000       80053            1
52     12000       82306            2
52     12000       82670            3
52     12000       84481            4

All Claim# has proc_Code = '80053' must be excluding.
I was using this :
(from Sarah, in https://www.cognoise.com/index.php/topic,35899.msg118504.html#msg118504)


c_ProcCodeInd: maximum ( if ( Proc_Code = '80053' ) then ( 'Y' ) else ( null ) for Claim_Nbr )
filter: c_ProcCodeInd = 'N'

Changed the filter to 'N' instead of 'Y'.
I filtered on one client name for testing, and my report run right. But when I turn filter Name off for the whole report, I got the wrong info. Claim number doesn't match up with Client name.

Any insight guys on how to proceed on this. Please share your thoughts. Let me know if it is unclear and I can add additional info. Thanks.

[Francis aka khayman]

try to change the filter from detail to summary... or after aggregation...