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

OTBI report on Project analysis

Accepted answer
18
Views
4
Comments
edited Jul 9, 2021 3:37PM in Project Management 4 comments

Summary

OTBI report on Project analysis

Content

Hi Experts,

I am creating OTBI report on project analysis. I got all the columns in work area. Now need to add one column with calculative value. The calculative column not accepting NVL formula. 

Business Scenario - Calculative column formula is - ColumnA - (ColumnB+ColumnC)

This above formula works perfect if values available in all column. When any one column has null value the output showing null.

Tried to use  NVL formula. But its not supporting showing error "[nQSError: 27042] Function NVL is not defined by administrator. (HY000)".

Could you please advise how to handle null values here.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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