Multi-expression formula

[sharvey90]

Crystal 8.5
Goldmine 6.0

I'm trying to say the following w/my formula,

If fieldname (CONTACT2.UGSTVALUE) is equal to "0.00" OR
If fieldname (CONTACT2.UGSTVALUE) is empty then "Not Yet Renewed" else "Renewed"

I have the following,
IF (isnull({CONTACT2.UGSTVALUE})) then "Not Yet Renewed" else "Renewed"

But, I don't know what to add to say:
If fieldname (CONTACT2.UGSTVALUE) is equal to "0.00"

I've tried several things, but I'm not getting it.

 

[sharvey90]

NEVERMIND, I got it.

If {CONTACT2.UGSTVALUE} = '0.0' then "Not Yet Renewed"
else (If (isnull({CONTACT2.UGSTVALUE})) then "Not Yet Renewed" else "Renewed")

 

[lbass]

I would try:

if isnull({CONTACT2.UGSTVALUE}) or
{CONTACT2.UGSTVALUE} = "0.0" then
"Not Yet "Renewed" else
"Renewed"

The isnull clause should be first ordinarily.

-LB

 

[Madawc]

As lbass says, you have to start with the null check. Otherwise Crystal will quit the formula when it finds a null value, and not bother about a subsequent test that would have handled null. Part of the design philosophy, and something we all have to get used to.

Madawc Williams (East Anglia)