CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

ODBC error when comparing picklist columns and trying to set a text value in column

edited Sep 11, 2014 5:00AM in CRM On Demand - Reports and Dashboards (MOSC) 4 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center