nvl

first determines if the value of the first parameter is null if it is, it returns the value of the second parameter syntax nvl(expr1, expr2) enabled for for a description of the business object categories, see notes on "enabled for" docid\ u26v9fecfs6ilwa0 pvjd business object category yes/no business rules before save rules yes business rules calculation rules (after save, with or without also recalculate on load) yes business rules calculation rules (before save or always, without also recalculate on load) yes business rules calculation rules (before save or always, with recalculate on load) yes business rules editing rules yes business rules initialization rules yes business rules read only rules yes business rules required rules yes business rules validation rules yes client expressions yes object permissions yes services yes ldap yes mobile yes quick actions (except ui quick actions) yes ui quick actions yes reports yes search/dashboard without field references yes search/dashboard with field references yes parameters parameter description expr1 the first expression expr2 the second expression return value text value returns the value of the expr1 parameter if the value of the expr1 parameter is not null returns the value of the expr2 parameter if the value of the expr1 parameter is null returns null if the values of both the expr1 and expr2 parameters are null example the following example tests the owner field to see if it is empty, and returns the appropriate message $(nvl(owner, "unknown owner")) nvl does not support multiple values to be used as parameter, therefore a list cannot be used as expr1 that is, a validated field cannot be used as expr1