ODBC error when comparing picklist columns and trying to set a text value in column
I am trying to add a column to a report where the value shown is either a "Yes" or a "No" based on comparing one picklist field to two other picklist fields. This is what I have:
First picklist value: Opportunity.PICK_28
Second picklist value: Opportunity.PICK_55
Third picklist value: Opportunity.PICK_56
Basically I need to show "Yes" if the first is equal to either the second one or the third. Otherwise is a "No".
I added the First picklist value column in the report and have the following on its formula:
CASE WHEN ((Opportunity.PICK_28 = Opportunity.PICK_55) OR (Opportunity.PICK_28 = Opportunity.PICK_56)) AND Opportunity.PICK_28 <> 0 THEN 'Yes' ELSE 'No' END