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
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