My Oracle Support Banner

R12: Projects: How to Use NVL in Calculated Custom Measure? (Doc ID 2235275.1)

Last updated on FEBRUARY 22, 2019

Applies to:

Oracle Project Planning and Control - Version 11.5.10.2 and later
Information in this document applies to any platform.

Goal

 How to use NVL in calculated custom measure?

Example:
Derive custom column 'Balance Budget' using Calculated Custom Measure say: CurBudgetRawCost- RawCost
If any RawCost is NULL, then custom measure should be total Budget amount, instead it gets calculated as NULL.

Using NVL(CurBudgetRawCost, 0)- NVL(RawCost, 0) while saving gives error 'NVL is not qualified db column name, please verify it with the base measure list'.

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.