Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
NVL on a CONCAT expression in a Cross tab report — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

NVL on a CONCAT expression in a Cross tab report

Received Response
edited Mar 19, 2018 7:43PM in Reporting & Analytics for B2C Service 4 comments



Please see screenshot below.

Where it says "no value", I am using the following:

nvl(concat(tasks.status_id, ' / ' , tasks.pct_complete),'-')

However, it's still outputting "No Value". What am I doing wrong? If there is not an associated task for that incident, I want to display a hyphen

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!