Last updated on MARCH 01, 2017
Applies to:Oracle Project Planning and Control - Version 220.127.116.11 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'.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms