Hi

I am fairly new to crystal and I am looking for some help with a formula.

I have crystal linked to an access database and I am looking for crystal to change the reporting of an amount to 0  if a parameter is not "Accepted" for certain deal numbers. I have tried using the If Then Else formula without success.

I am trying to write a formula that = If the {Crystal_reports_query_finance.Deal No} is equal to (9138) and the {Crystal_reports_query_finance.Saving Accepted ?} does not = “accepted” then change the {Crystal_reports_query_finance.Charges in Local Currency} to 0

I hope this makes sense and somebody can point me in the right direction.

Thanks