Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
OTBI report on Project analysis — 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

OTBI report on Project analysis

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


OTBI report on Project analysis


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.


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