numer property set as 0 for empty

[SMomo]

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?

[karstenkoehler]

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

[SMomo]

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

[karstenkoehler · Accepted solution]

@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.