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? 

 

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

 

 

Best Answer

  • clloyd01
    clloyd01 ⚪️
    Accepted Answer

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