Syntax error near AS
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!
