Calculated property: Fix error for blank fields

Status: Idea Submitted

Calculated properties are great to combine different factors e.g. revnue into one distinct data field.

However, it was very unclear to me and the team that leaving a field blank prevents properties from calculating. This should be fixed in one the following ways:

1: Give an error message so the user understands why it doesnt calculate.

2: Calculate the field without the number e.g. when this is a sum.

3: Default to 0 when the field is left blank or ask the user when creating the property what the default should be.

Thanks!

Amen to that - I was looking for an option to that either allows me to set a number property to “0” by default or simply treat an empty field as “0” in order to still run a calculation.

Instead now I’m setting up a WF that sets my empty number fields to 0 - seems unneccesary busy work…