I am trying to change the output of a smartlist to match what a vendor requires, so instead of receiving Married, it needs to be '2', and male needs to be '1' etc. I figured this to be an easy project, but I seem to "break" the smartlist every time I write a case function to do this. here is an example:
CASE WHEN {Payroll Master:MARITAL STATUS} = 'SINGLE' THEN '1'
WHEN {Payroll Master:MARITAL STATUS} = 'MARRIED' THEN '2'
ELSE '1' END
or
CASE WHEN {Payroll Master:MARITAL STATUS} = 'single' then '1'
--WHEN {Payroll Master:MARITAL STATUS} = 'married' THEN '2'
ELSE '2'
END
I set the field name and the field type is string
Any help would be greatly appreciated!
