Report Design: "Or IF" function error

Print Page | Close Window

"Or IF" function error

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=15386
Printed Date: 18 May 2024 at 12:26pm

Topic: "Or IF" function error

Posted By: colinh10
Subject: "Or IF" function error
Date Posted: 17 Jan 2012 at 12:06am

I have been trying to create an addition to a crystal formula and cannot get it to work, the formula i have tried is as follows:

If {'GPD_Data_'.Deal No}= [0000,9452,9427] and {'GPD_Data_'.Saving Accepted ?} <> ["1-Accepted","Unknown"] then 0 else {'GPD_Data_'.% Charges in GBP} or if {'GPD_Data_'.Deal No}= [9281] and {'GPD_Data_'.Saving Accepted ?} = ["13-Itinerary Changed,6-Cancelled"] then 10 else {'GPD_Data_'.% Charges in GBP}

The text in red is the additional function I want to perform the formula before this works ok.

I am using Crystal 10 Can anybody ssee my problem?

Many Thanks

Colin

Replies:

Posted By: FrnhtGLI
Date Posted: 17 Jan 2012 at 2:07am

Try:

If {'GPD_Data_'.Deal No}= [0000,9452,9427] and {'GPD_Data_'.Saving Accepted ?} <> ["1-Accepted","Unknown"]
     then 0
          else
if {'GPD_Data_'.Deal No}= [9281] and {'GPD_Data_'.Saving Accepted ?} = ["13-Itinerary Changed,6-Cancelled"]
     then 10
          else {'GPD_Data_'.% Charges in GBP}

-------------
|< /\ '][' ( )

Posted By: colinh10
Date Posted: 17 Jan 2012 at 2:23am

Thank you seems to have done the trick!

Print Page | Close Window