In SQL Transform, I have...
SELECT * WHERE
(CASE
WHEN (FcstName LIKE '%Fcst%' AND 'Rev Month' = 1) THEN ('Margin EV'*0.314/GM_Pct)
ELSE 'Margin EV'
END)
AS MarginEVAdj
FROM sales_pipeline
I'm getting a syntax error "Near AS", but can't figure out what's wrong.
Thanks!