# Fallback value as 0 or 'NA' For named query binding result null/ NULL?

**URL:** <https://forum.inductiveautomation.com/t/fallback-value-as-0-or-na-for-named-query-binding-result-null-null/71810>\
**Category:** Ignition\
**Tags:** perspective, ignition81\
**Created:** [March 30, 2023, 4:32am UTC](https://forum.inductiveautomation.com/t/fallback-value-as-0-or-na-for-named-query-binding-result-null-null/71810 "2023-03-30T04:32:52Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Bhavik\_Patel](https://avatars.discourse-cdn.com/v4/letter/b/d78d45/32.png) [@Bhavik\_Patel](https://forum.inductiveautomation.com/u/Bhavik_Patel)\
**Post date:** [March 30, 2023, 4:32am UTC](https://forum.inductiveautomation.com/t/fallback-value-as-0-or-na-for-named-query-binding-result-null-null/71810/1 "2023-03-30T04:32:52Z")

</div>

How to configure Fallback value as 0 or 'NA' to component in perspective while binding with named query result null/ NULL?

It is showing overlay error on Perspective component.

---

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [March 30, 2023, 8:48pm UTC](https://forum.inductiveautomation.com/t/fallback-value-as-0-or-na-for-named-query-binding-result-null-null/71810/2 "2023-03-30T20:48:31Z")

</div>

![Query null transform](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/b/cb98f35e998264a216946a0dc2f2732e3d5af564.png)

1. Named query binding.
2. My test query.
3. Add a transform ...
4. ... of the Expression variety.
5. Test for `ìsNull()`.
6. The result.

---

<div class="post-metadata">

**Author:** ![Matthew.gaitan](https://avatars.discourse-cdn.com/v4/letter/m/59ef9b/32.png) [@Matthew.gaitan](https://forum.inductiveautomation.com/u/Matthew.gaitan)\
**Post date:** [March 30, 2023, 9:09pm UTC](https://forum.inductiveautomation.com/t/fallback-value-as-0-or-na-for-named-query-binding-result-null-null/71810/3 "2023-03-30T21:09:44Z")

</div>

Alternatively,

you can use the `coalesce` expression

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/c/3c684d5b98bf4cb3217921bd041805e17e5a665b.png)