IF THEN ELSE problem

krazykasper

Registered User.
Local time
Today, 06:22
Joined
Feb 6, 2007
Messages
35
I have a formula in my Crystal Report as follows.
It works fine except it doesn't identify records when Sum ({@ExcessUsageAsOfDecember31},{OptimizeIt.LeaseMasterContractId}) is NULL. I tried inserting IS NULL in several places but keep getting syntax errors. I appreciate it anyone can help me finish off this formula.

IF {OptimizeIt.ContractStartDate} in DateTime (2008, 04, 16, 00, 00, 00) to DateTime (2008, 12, 31, 00, 00, 00)
AND Sum ({@ExcessUsageAsOfDecember31}, {OptimizeIt.LeaseMasterContractId}) <=7600
AND Sum ({@ExcessUsageAsOfApril15}, {OptimizeIt.LeaseMasterContractId}) <=7600
THEN "1st Audit - Letter B"
ELSE "TBD"

Krazy (Bill) Kasper
 

Users who are viewing this thread

Back
Top Bottom