Formula For All Others = "Other" ??? 2

[loveyoursite]

CRV10 - For this formula, could someone please tell me what to add if I want all other {PCODES.DESCRIPTION}'s to show as "Other". This formula does what I want it to do except anything not RN, LPN or CNA shows on the report as a blank instead of "Other". Thanks!

if {PCODES.DESCRIPTION} = "Registered Nurse" then "RN" else
if {PCODES.DESCRIPTION} = "Licensed Practical Nurse" then "LPN" else
if {PCODES.DESCRIPTION} = "Certified Nursing Assist" then "CNA" else
"Other

 

[BobSuruncle]

You may have NULLS to deal with.
try this:

If ( IsNull({PCODES.DESCRIPTION}) 
    or Trim({PCODES.DESCRIPTION}) = '' )
then "Other"
Else
if {PCODES.DESCRIPTION} = "Registered Nurse" then "RN" 
else
if {PCODES.DESCRIPTION} = "Licensed Practical Nurse" then "LPN" 
else 
if {PCODES.DESCRIPTION} = "Certified Nursing Assist" then "CNA" else
"Other"

Bob Suruncle

 

[synapsevampire]

It may be a null issue, so try:

if isnull({PCODES.DESCRIPTION})
or
not({PCODES.DESCRIPTION} in ["Registered Nurse" ,"Licensed Practical Nurse", "Certified Nursing Assist"]) then
"Other"
else
if {PCODES.DESCRIPTION} = "Registered Nurse" then
"RN"
else
if {PCODES.DESCRIPTION} = "Licensed Practical Nurse" then
"LPN"
else
if {PCODES.DESCRIPTION} = "Certified Nursing Assist" then "CNA"

-k

 

[loveyoursite]

Thank you both! That's exactly what it was. The field did contain other named certifications and it was blank if there were no certifications.

THANKS SO MUCH!!!!