Use a case statement to return a value in another column

clloyd01

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? 

 

(CASE
When `Opp Status` = Won
Then `Annual Value`
Else 0
end)

 

 

clloyd01

All is well....forgot the ''s on Won....

 

 

clloyd01

All is well....forgot the ''s on Won....