Probs with if/else formula 1

[Parkypark]

I have a simple if / else formula, which i wish to expand on.
Please can some one point me in the right direction

what I have already
is
if {priority} ='medium' and {business hours} >8.00 then "Fail"
else
"Pass"

This works fine, but my report has 3 possibilities
Fail, Pass and Unassigned

How do I if / else the 3 possibilities

I have tried multiple else statements but I ended up with 4 catergories, of Fail , pass, Unassigned, and blank.

Help, b4 if Throw my Crystal machine out the window.

 

[stormtrooper]

You will have to use else/if. But what is your criteria?

 

[dgillz]

If there is a possibililty that you have a null value, you need to test for it first using the isnull() function. Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com

 

[kenhamady]

It would be something like this:

if {priority} ='medium' and {business hours} >8.00
then "Fail"
else

if {priority} ='medium' and {business hours} <= 8.00
then &quot;Pass&quot;
else &quot;Unassigned&quot;
Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[Parkypark]

Ken
I have tried this and I get pass, fail and blank

My business hrs will be a null value (blank field )if unresponded
does this help

cheers
Parky

 

[kenhamady]

Your first If should be the one for null values:

If IsNull ({field})
then ... Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[Parkypark]

Thanks ken It worked a treat

I am also having trouble with more date fields
see more date probs


once again thanks