Hello all. I am trying to use 3 case statements to evaluate 3 fields in a table. If any one of the fields contains a case value then count it for the text value. I can get values for the first field but do not know the syntax to add the second and third fields to the same formula can someone help?
CASE Satisq_ER."Q3"
When 1 THEN 'Physician'
When 2 THEN 'Convenient'
When 3 then 'Family/Freind Rec.'
When 4 then 'Care Better'
When 5 then 'Insurance'
When 6 then 'Cost Lower'
When 7 then 'Only Hospital in Area'
When 8 then 'Other'
END;
CASE Satisq_ER."Q3"
When 1 THEN 'Physician'
When 2 THEN 'Convenient'
When 3 then 'Family/Freind Rec.'
When 4 then 'Care Better'
When 5 then 'Insurance'
When 6 then 'Cost Lower'
When 7 then 'Only Hospital in Area'
When 8 then 'Other'
END
CASE Satisq_ER."Q3"
When 1 THEN 'Physician'
When 2 THEN 'Convenient'
When 3 then 'Family/Freind Rec.'
When 4 then 'Care Better'
When 5 then 'Insurance'
When 6 then 'Cost Lower'
When 7 then 'Only Hospital in Area'
When 8 then 'Other'
END;
CASE Satisq_ER."Q3"
When 1 THEN 'Physician'
When 2 THEN 'Convenient'
When 3 then 'Family/Freind Rec.'
When 4 then 'Care Better'
When 5 then 'Insurance'
When 6 then 'Cost Lower'
When 7 then 'Only Hospital in Area'
When 8 then 'Other'
END