Can someone please help? I am having difficulties lableing blank fields using a case statement formula. Example:
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'.