Calculation Property Doesn't Work if a Property is BlankSOLVE
Feb 5, 2019 5:56 PM
Currently, we have the enterprise level HubSpot account and have been working on creating calculation properties to add together transactional pieces. There is a major roadblock with this property as it doesn't allow a calculation formula to run if there is a blank property. Is there any sort of workaround for this problem?
Solved! Go to Solution.
Nov 5, 2020 11:13 AM - edited Nov 8, 2020 8:54 AM
I tested this with a customer today. Setting the properties included in the calculation property to 0 did work.
To configure this, you can:
- Create the calculated property using two number properties.
- On the contact record, add 0 for any values that are unknown.
When the value for Number property 2 is blank, the Calculated number property is unknown.
When the value for Number property 2 is 0, the Calculated number property is calculated.
I hope this helps! Please let me know if you have any questions!
Melinda | (She/Her)
Customer Support Specialist