# Can a number formula return nothing instead of zero?

**URL:** <https://community.fibery.io/t/can-a-number-formula-return-nothing-instead-of-zero/6278>\
**Category:** Get Help\
**Created:** [June 6, 2024, 9:00pm UTC](https://community.fibery.io/t/can-a-number-formula-return-nothing-instead-of-zero/6278 "2024-06-06T21:00:45Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![ccollins](https://avatars.discourse-cdn.com/v4/letter/c/bbe5ce/32.png) [@ccollins](https://community.fibery.io/u/ccollins)\
**Post date:** [June 6, 2024, 9:00pm UTC](https://community.fibery.io/t/can-a-number-formula-return-nothing-instead-of-zero/6278/1 "2024-06-06T21:00:45Z")

</div>

In a number formula, is there anyway to default to [empty] if the formula’s conditions are not met? For this specific field, there are some entities that this formula doesn’t apply to. But I don’t want the field to say “0%”. I just want the field to be blank.

I know I could technically convert it to a text field, but I’m trying to use the progress bars.

---

<div class="post-metadata">

**Author:** ![Matt\_Blais](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/matt_blais/32/1464_2.png) [@Matt\_Blais](https://community.fibery.io/u/Matt_Blais)\
**Post date:** [June 6, 2024, 9:14pm UTC](https://community.fibery.io/t/can-a-number-formula-return-nothing-instead-of-zero/6278/2 "2024-06-06T21:14:31Z")

</div>

Related: [Allow to return an empty value from a formula](https://community.fibery.io/t/allow-to-return-an-empty-value-from-a-formula/2983)

11 votes! 😀
