Hi!
We do a lot of expense calculations within hubspot using multiple equations.
Currently creating calculations is very time consuming because we have a lot of the below scenario (which has been greatly simplified for this example).
X+Y=Z (Conditional)
A+B=C (Conditional)
Z+C=V
Since Z and C are conditional, there are many times that the value is unknown and therefore V cannot compute. Having the ability to toggle that a calculation field being unknown is seen as zero would save so much time!
My current workaround is that I have workflows that copy Z and C (calculations) to Z and C (number fields) if known and sets them to 0 if unknown. So the Z and C (number fields) are then able to be used in the final calculation of V.
Adding the ability to set the calculation field to 0 if unknown would be amazing and save us so much extra work!
Thanks!