Skip to main content

I have a configuration formula that takes input from Characteristics to derive a number.  However some of the characteristics are removed based on sales rules, then then causes those to have a value of NULL - this then makes the formula error.

 

Here is the example of what we face when the formula runs:

 

I’ve glanced through the Function, but I didn’t see a IsNULL and I can’t find a definition for the Function list.

 

For the future person that needs assistance with this.

Built Function NVL solve this:

(NVL(INVPTQ1,0) * 5) + 2

 

For those wondering documentation on the Built-In Functions, these are standard PL/SQL Functions and looking those up will assist with that documentation.

Terms & ConditionsCookie settingsAccessibility statement