Hi I am trying to use a case statement with a When and Then clause inside it. The formula I am putting in is basic and has worked for other tables but not working for the one I am currently working with.
I have tried these formulas:
1.
CASE `SeasonalDescription`
WHEN 'Easter'
THEN 'Spring and Summer'
ELSE 'Other'
END
2.
CASE TRIM(`SEASONALDESCRIPTION`)
WHEN 'Easter'
THEN 'Spring and Summer'
ELSE 'Other'
END
3.
CASE 'Easter' IN (`SEASONALDESCRIPTION`)
THEN 'Spring and Summer'
ELSE 'Other'
END
All 3 of these formulas are giving me only the value 'other' they are not reading the 'easter' value and giving me the then clause of 'Spring and Summer'. Like i have said this formula same way has worked with other tables just not working this time around and it has been validated by beast mode too.