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.
try to change the filter from detail to summary... or after aggregation...