Using mulitple IF statements - help!

[Pagey]

I am trying to create a report using CR7 taking data from a Remedy database, but am running into a few problems! I have a formula field using the following code :

if {PSHD_S_HELPDESK.Revised_Close_Time} >0 then
if {PSHD_S_HELPDESK.Revised_Close_Time}- {PSHD_S_HELPDESK.Fix_By} <= 0
then
&quot;YES&quot;
else
&quot;NO&quot;
else
if {PSHD_S_HELPDESK.SLA_Fix} = 0 then
&quot;NO&quot;
else
&quot;YES&quot;

What I hope this is supposed to do is look at the Rev_close_time field, if there is a figure, carry out the next if statement, if not, go to the last if statement, and then fill in the field with either YES or NO. CR tells me there are no errors, but there is no data appearing! As the rev_close_time field should be NULL when no data - would using the zero cause this effect? If so, how would you use NULL in that formula?! Any help would be greatly appreciated!
Regards
Chris

 

[dgillz]

Change the first THEN to AND, and get rid of the else &quot;NO&quot; before the else if statement.

Null check like this -- If IsNull({fieldname}) Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office