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 laterInformation 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 |