Replaces a null value in a field with a specified value in Salesforce Spiff.
Required Editions
| Available in: both Salesforce Classic (not available in all orgs) and Lightning Experience |
| Available in: Enterprise, Unlimited, and Developer Editions |
| Available for an additional cost in: Professional Edition with Web Services API Enabled |
Syntax
ifnull(field, if_null_value)Arguments
| Argument | Required? | Description |
|---|---|---|
| field | Required | The field to check for a null value. |
| if_null_value | Required | The value to use for the field if the current value is null. |
Example
Check whether the ARR__c field is null, and replace any null values with 0.
=ifnull(ARR__c, 0)