CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

Replace "Unspecified" with ''

edited Jun 25, 2014 5:50PM in CRM On Demand - Reports and Dashboards (MOSC) 4 commentsAnswered ✓

I am building multiple reports on:

-  Service Request object (Picklist Field)

- Contact object (Contact Role value)

If the picklist or Contact role values are blank it fills the value "UNSPECIFIED". We need to replace it with a NULL or '' value.

I tried the following formats but none of them give me the correct answer:

IFNULL("- Role"."Account Contact Role", ' ')

IFNULL("- Role"."Account Contact Role", '')

I tried the following:

CASE

WHEN "- Role"."Account Contact Role" = 'Unspecified'

THEN ''

ELSE "- Role"."Account Contact Role"

END

This does give me the correct results, but is this the correct method?

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