Crystal Formula

[SaiCrystal]

Hi All,

My report has the following data:

Name ClaimNumber PaymentDate Status
A 1 1/1/2009 Adjusted
A 1 1/1/2009 Paid




I need a formula for:

If Name = Name and
ClaimNumber = ClaimNUmber and
PaymentDate = PaymentDate

then Status where Paid replace with Adjusted.


Expected Result:

Name ClaimNumber PaymentDate Status
A 1 1/1/2009 Adjusted



Please Help. Thanks

 

[fisheromacse]

I do not have crystal in front of me, so apologize if i have any typos or missed something, but maybe something like this:

group on Claim Number, then on Status (sorted ascending)

//{@adj}
IF onfirstrecord=TRUE
THEN {table.Status}
ELSE
(
IF ({table.name}=previous{table.name}
AND
{table.Claimnumber}=previous{table.Claimnumber}
AND
{table.PaymentDate}=Previous{table.paymentdate}
AND
{table.Status}='Paid')
THEN 'Adjusted'
ELSE {table.status}
)

 

[SaiCrystal]

Thank you so much.
I really appreciate your help.
It worked.

 

[fisheromacse]

glad i could help....and on a zombie-brained friday afternoon at that! hehehe