R12: Projects: How to Use NVL in Calculated Custom Measure?
(Doc ID 2235275.1)
Last updated on MARCH 01, 2017
Applies to:Oracle Project Planning and Control - Version 126.96.36.199 and later
Information in this document applies to any platform.
How to use NVL in calculated custom measure?
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'.
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