Hi, Here is my CASE statement which is returning an syntax error: I Need to add Case when statement with else statements. CASE WHEN {transactionlines.custcol_proj_category_on_a_click} IN ('IT Ops & IS','DWS & DO') AND {transactionlines.custcol_project_entity_id} IN ('BRTP00415','BRTP00418') THEN 'DWS' else 'Digital Office'\nWHEN {transactionlines.custcol_proj_name_on_a_click_report} LIKE 'Fresher' AND {transactionlines.custcol_onsite_offsite}='Offsite' THEN 'Fresher Bench - Offshore' else 'Fresher Bench - Onsite' END

You only get one ELSE in a CASE