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 zero (0) using the NVL function. Add the NVL function on every field on the Default Value tab of the custom field.
- Navigate to Customization > Lists, Records, & Fields > Transaction Body Fields > New
- Label: Enter Label
- Store Value: Remove Checkmark
- Click Applies To
- Desired Transactions: Enter Checkmark
- Click Validation & Defaulting
- Formula: Enter Checkmark
- Default Value: Enter NVL({customfield1},0) + NVL({customfield2},0)
Note: Replace customfield1 and customfield2 with the reall custom field IDs.
6.Click Save