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
Send us your feedback: We're always looking for advice to help improve our Knowledge Base! Please let us know if this article was helpful or provide feedback on how we can improve your experience here.
Thank you