What kind of error are you getting ?
I am thinking it is because you are trying to assign a value to the {Crystal_reports_query_finance.Charges in Local Currency}. Why don't you create a formula field. Call it "local currency" (or whatever you want) and add the formula:
If {Crystal_reports_query_finance.Deal No} = 9138 and {Crystal_reports_query_finance.Saving Accepted ?} <> “accepted” then
0
else
{Crystal_reports_query_finance.Charges in Local Currency}
This will assign "local currency" the value of "Crystal_reports_query_finance.Charges in Local Currency" or 0, depending on the if statement.
Move this field "local currency" to your report in place of the {Crystal_reports_query_finance.Charges in Local Currency} field.
Give it a try !
IP Logged
