Overview:
A Formula Field does not properly increment number fields inside Vault.
Root Cause:
Formula Fields by default are set to Treat blank values as blanks. This causes a field with a blank value to carry the blank value instead of an incremental value.
Solution:
In order for incrementing to work with a blank field value, the option for Treat blank values as zeros must be enabled. To do so:
- Navigate to the formula field in the Entry Actions menu.
- Press the Calculator button
. - Press Advanced Settings drop-down menu.
- Change the Blank Field Handling option to Treat blank fields as zeros.
Related Documentation:
Vault Help Documentation: Setting Fields with Formulas
Thank you