topic Re: numer property set as 0 for empty in Blog, Website & Page Publishing

numer property set as 0 for empty

SMomo — Mon, 17 Mar 2025 08:48:09 GMT

I am using a number property in a calculation. But the calculation won't work if the number property is empty. is there any way to set 0 for empty in the number property?

Re: numer property set as 0 for empty

karstenkoehler — Mon, 17 Mar 2025 08:50:45 GMT

Hi @SMomo,

What exactly should the calculation return if the number property is empty? Can you share a screenshot of your calculation?

Generally, you can use "is known" to check if the property has a value or not and/or an if statement to decide what should be returned when it isn't. https://knowledge.hubspot.com/properties/create-calculation-properties

Best regards

Re: numer property set as 0 for empty

SMomo — Mon, 17 Mar 2025 08:56:54 GMT

I have added the image for the calculated property. I want this formula to work even if the scholarship amount is empty.

Re: numer property set as 0 for empty

karstenkoehler — Mon, 17 Mar 2025 09:00:13 GMT

@SMomo in that case, please see my previous reply, you can use an if statement and is_known to check whether the value is known, and if not, return 0:

if(is_known(property),property,0)

would translate to: return the value if it is known, return 0 if it isn't.