When there are two custom fields with Type = Integer Number and a third one is created in order to calculate their values, the formula used on the third field does not work, when one of the two custom fields is blank. To resolve this, use a formula that converts the null value to a… Continue reading Compute Custom Fields with Blank or Null Values
Tag: NVL function
NVL Function
NVL(expr1, expr2) : In SQL, NVL() converts a null value to an actual value. Data types that can be used are date, character, and number. The data type must match with each other i.e. expr1 and expr2 must be of the same data type. Syntax – NVL (expr1, expr2) expr1 is the source value or… Continue reading NVL Function