Show available rooms for null values

[DeShaun]

Hello,

I am needing some help writing a crystal report formula to pull null values for availability. I am an academic scheduler and I would like to be able to pull a list of available classes by term.

I have attempted to write the following formula:
if (isnull ({room})) and
If ({time} = "0800") and
if ({day} = "MWF") and
then {room}+ " "+{time}

 

[kray4660]

In the formula expert. Did you select 'Default Values for NULLs'? Also normally would put all three statement in one if (you have nested the ifs in a non standard way)

if (isnull ({room})) and
({time} = "0800") and
({day} = "MWF") and
then {room}+ " "+{time}

 

[DeShaun]

I have attempted to add the nested if statement you provide, but I am receiving a " number, currency amount, Boolean, date, time string expected" error.

 

[DeShaun]

Also could get the same results if a I did a subreport formula?

 

[lbass]

For one thing, remove the "and" before the "then".

-LB

 

[DeShaun]

Thank you I figured that out.

 

[kray4660]

Opps!, trying to do a quick copy and paste and remove the extra ifs. me bad !!!