OTBI report on Project analysis
SummaryOTBI report on Project analysis
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.