Discussions
Formula field - multiple Case statements
Hello,
I have a formula field
CASE WHEN {custrecordsfcountry} = 'Cyprus' THEN 'CY'
WHEN {custrecordsfcountry} = 'South Africa' THEN 'ZA'
when {custrecordsfcountry} = ‘Ukraine’ then 'UA'
when {custrecordsfcountry} = ‘Turkey’ then 'TR'
when {custrecordsfcountry} = ‘Tunisia’ then 'TN'
when {custrecordsfcountry} = ‘Senegal’ then 'SN'
when {custrecordsfcountry} = ‘Saudi Arabia’ then 'SA'
when {custrecordsfcountry} = ‘Russian Federation’ then 'RU'
when {custrecordsfcountry} = ‘Reunion’ then 'RE'
when {custrecordsfcountry} = ‘Qatar’ then 'QA'
when {custrecordsfcountry} = ‘Oman’ then 'OM'
when {custrecordsfcountry} = ‘Mauritius’ then 'MU'
when {custrecordsfcountry} = ‘Monaco’ then 'MC'
when {custrecordsfcountry} = ‘Morocco’ then 'MA'
when {custrecordsfcountry} = ‘Latvia’ then 'LV'
when {custrecordsfcountry} = ‘Lithuania’ then 'LT'
when {custrecordsfcountry} = ‘Lebanon’ then 'LB'
when {custrecordsfcountry} = ‘Kazakhstan’ then 'KZ'