# numer property set as 0 for empty

**URL:** <https://community.hubspot.com/t/numer-property-set-as-0-for-empty/128056>\
**Category:** Blog, Website & Page Publishing\
**Tags:** enterprise\
**Created:** [March 17, 2025, 8:48am UTC](https://community.hubspot.com/t/numer-property-set-as-0-for-empty/128056 "2025-03-17T08:48:09Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![SMomo](https://avatars.discourse-cdn.com/v4/letter/s/ea666f/32.png) [@SMomo](https://community.hubspot.com/u/SMomo)\
**Post date:** [March 17, 2025, 8:48am UTC](https://community.hubspot.com/t/numer-property-set-as-0-for-empty/128056/1 "2025-03-17T08:48:09Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\
**Post date:** [March 17, 2025, 8:50am UTC](https://community.hubspot.com/t/numer-property-set-as-0-for-empty/128056/2 "2025-03-17T08:50:45Z")

</div>

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. [Create calculation and rollup properties](https://knowledge.hubspot.com/properties/create-calculation-properties)

Best regards

---

<div class="post-metadata">

**Author:** ![SMomo](https://avatars.discourse-cdn.com/v4/letter/s/ea666f/32.png) [@SMomo](https://community.hubspot.com/u/SMomo)\
**Post date:** [March 17, 2025, 8:56am UTC](https://community.hubspot.com/t/numer-property-set-as-0-for-empty/128056/3 "2025-03-17T08:56:54Z")

</div>

![Screenshot 2025-03-17 at 9.54.59 AM.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/6/6e77732c99436d7acd037482c0f6351f5f3bb1f5.png)

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

---

<div class="post-metadata">

**Author:** ![karstenkoehler](https://d10pqhm3lwygmk.cloudfront.net/user_avatar/community.hubspot.com/karstenkoehler/32/68554_2.png) [@karstenkoehler](https://community.hubspot.com/u/karstenkoehler)\
**Post date:** [March 17, 2025, 9:00am UTC](https://community.hubspot.com/t/numer-property-set-as-0-for-empty/128056/4 "2025-03-17T09:00:13Z")

</div>

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

 ![karstenkoehler_0-1742201946099.png](https://d2qpr2jzcazej7.cloudfront.net/original/2X/2/2b9e680b37f0570ae54185779b6a3cb63e1df291.png)

_if(is\_known(property),property,0)_

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