Print Page | Close Window

"Or IF" function error

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
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: 01 May 2025 at 10:36pm


Topic: "Or IF" function error
Posted By: colinh10
Subject: "Or IF" function error
Date Posted: 17 Jan 2012 at 12:06am
Hi
 
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