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…

Any updates on this? I just ran into the same challenge and I’m hoping someone has a work around. Thanks.

Hello Steve, Unfortunately, I’ve reached out to many HubSpot Support team members and they were unable to provide an accepta…

Just want to add a workflow to make sure that all blank properties used in calcuated property formulas are auto-updated to ze…

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…

Thank you MHill4, What should be the value for Constant 1 in the formula or should I create a new porperty named Constant 1? …

Calculation Property Doesn't Work if a Property is Blank

CleberAlexandre July 19, 2023, 9:11pm 13

Where can I configure this?

Topic		Replies	Views
Consider empty fields in a calculation as 0 HubSpot Ideas object	49	19844	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	4480	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