Use a case statement to return a value in another column

Hello -


I'm trying to return a value in one column when there is a certain value in another column. When using the Case statement below, I get an error that a column doesn't exist...but it definately does. Any insight? 


When `Opp Status` = Won
Then `Annual Value`
Else 0



Best Answer