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

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

Content

Hi,

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.

Register

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