# Return null value in equation

**URL:** <https://forums.knack.com/t/return-null-value-in-equation/7234>\
**Category:** Get Answers\
**Created:** [December 8, 2017, 4:46pm UTC](https://forums.knack.com/t/return-null-value-in-equation/7234 "2017-12-08T16:46:09Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Adam64345](https://avatars.discourse-cdn.com/v4/letter/a/71e660/32.png) [@Adam64345](https://forums.knack.com/u/Adam64345)\
**Post date:** [December 8, 2017, 4:46pm UTC](https://forums.knack.com/t/return-null-value-in-equation/7234/1 "2017-12-08T16:46:09Z")

</div>

Hi there,

I was wondering if there was any way to return a null value in an equation as part of a ternary operator. For example:

{Value} == 1 ? {Value} : _null_

Right now, this would return a 0 - which doesn't working for me as I'm trying to use it in concert with the 'exclude empty columns' option for tables.

Cheers,

Adam

---

<div class="post-metadata">

**Author:** ![CharlesP72336](https://avatars.discourse-cdn.com/v4/letter/c/9dc877/32.png) [@CharlesP72336](https://forums.knack.com/u/CharlesP72336)\
**Post date:** [March 9, 2018, 4:52pm UTC](https://forums.knack.com/t/return-null-value-in-equation/7234/2 "2018-03-09T16:52:12Z")

</div>

Any input on this? I really need to return a {blank} or null value here, not a zero... If you return a zero, then it screws up average calculations among other things... My current scenario is different, but I am also wondering if there is a way to have a completely "blank" cell returned after a particular formula or response.

I even tried setting the response to a separate field which I intentionally leave blank, but this also defaults to a value of $0.00.

Help?