Blank Field Handling section on a formula field
|Knowledge Article Number||000233669|
For custom formula fields, there is a Blank Field Handling section. This section is accessible when you click Edit on the formula field within Setup and is used if your formula references any number, currency, or percent fields. You can specify what happens to the formula output when their values are blank.
The two options are:
To give any blank fields a zero value, choose Treat blank fields as zeros. To leave these fields blank, choose Treat blank fields as blanks.
From the example above, here are your two outcomes depending on your selection of Blank Field Handling
Formula Operators and Functions I–Z