Skip to Content
0
Former Member
Mar 05, 2015 at 04:09 PM

Case Statement Formula

25 Views

Can someone please help? I am having difficulties lableing blank fields using a case statement formula. Example:

select {Mtr_Test.Action_Type_Cd}

case ' ' : 'No Action Taken'

case '0' : 'No Action Taken'

case '1' : 'Send to Manufacturer RMA'

case '2' : 'Repaired in Shop'

case '3' : 'Retired'

default : 'Not Found'

I would like to treat a blank field the same as if it where case '0' : 'No Action Taken'.