Hello, Currently, we have the enterprise level HubSpot account and have been working on creating calculation properties to a…

Hi all, I tested this with a customer today. Setting the properties included in the calculation property to 0 did work. To …

In case anyone stumbles upon this like I did - I also couldn’t get this to work and instead used workflows to set the default…

Alternative solution without using a workflow: Use Advanced Mode in the Calculation Property and combine if and is_present fu…

I couldn’t use `is_present` for some reason. I wound up setting the unknown values to 0 within the formaul like: if(is_known…

This is the best answer here and it helped me. Using this, I was able to get a working version that prefills all contacts wit…

I’m not sure how this solution would help if the calculation property is calculating “Time Between”. How do you put in a 0 va…

Where can I configure this? On the contact record, add 0 for any values that are unknown.

@MFrankJohnson Hi, Frank, I’m running into this exact issue now - Is there a best practice to set multiple default values t…

The simplest way I have found to do this is as follows: First we want to check the value to see if there is anything enter…

I’ve built workflows that set the property to 0 if unkown but then the problem is if you have a calculation property that ref…

Hi All, I believe I may have found a solution to this issue. A bit of effort upfront, but it definitely works! Lets say: Pr…

Sorry, by Constant 1, I just meant the number 1. In the calculation property A for example, your formula would be: (Property…

Hi @MHill4 Thanks for this workaround. Could you maybe share a screenshot of your solution? I cannot get it to work myself -…

At first: big shame on Hubspot that the paying users have to find workarounds for problems like this - problems, that appeare…

Calculation Property Doesn't Work if a Property is Blank

andresmorera October 28, 2021, 3:27pm 18

Thank you MHill4,

What should be the value for Constant 1 in the formula or should I create a new porperty named Constant 1?
Thanks for clarifying.
Andres

Topic		Replies	Views
Consider empty fields in a calculation as 0 HubSpot Ideas object	49	19846	September 2, 2026
Calculated property: Fix error for blank fields HubSpot Ideas properties	1	1088	May 29, 2024
Allow Calculated fields to be defaulted to 0, so they don't break dependent calculated fields. HubSpot Ideas properties	13	4485	November 3, 2025
Ability to add 'IF' statements to formulas behind Calculated Properties. HubSpot Ideas properties	1	1172	May 22, 2024
Error creating calculation property with Properties API APIs & Integrations developer-tools	10	8220	June 6, 2023