# Query returns cause field to error

**URL:** <https://forum.inductiveautomation.com/t/query-returns-cause-field-to-error/7381>\
**Category:** Ignition\
**Created:** [October 7, 2013, 4:19pm UTC](https://forum.inductiveautomation.com/t/query-returns-cause-field-to-error/7381 "2013-10-07T16:19:18Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![lcs226](https://avatars.discourse-cdn.com/v4/letter/l/848f3c/32.png) [@lcs226](https://forum.inductiveautomation.com/u/lcs226)\
**Post date:** [October 7, 2013, 4:19pm UTC](https://forum.inductiveautomation.com/t/query-returns-cause-field-to-error/7381/1 "2013-10-07T16:19:18Z")

</div>

I have the following query

SELECT Sum(Dessert\_Auction.Cash) AS SumOfCash, Status  
FROM dessert\_auction  
WHERE EventName = ‘{Auction\_System/Event\_Name}’  
AND Year = {Auction\_System/Event\_Year}  
AND Status = 1

With the fallback value enabled and set to “0”. My text field ‘NaN’ if the query returns with no values.

How can I display a test or number that I want?

---

<div class="post-metadata">

**Author:** ![jaepark](https://avatars.discourse-cdn.com/v4/letter/j/c6cbf5/32.png) [@jaepark](https://forum.inductiveautomation.com/u/jaepark)\
**Post date:** [October 7, 2013, 4:44pm UTC](https://forum.inductiveautomation.com/t/query-returns-cause-field-to-error/7381/2 "2013-10-07T16:44:45Z")

</div>

Try using COALESCE

`
SELECT COALESCE(Sum(Dessert_Auction.Cash),0) AS SumOfCash, Status
FROM dessert_auction 
WHERE EventName = '{Auction_System/Event_Name}' 
AND Year = {Auction_System/Event_Year}
AND Status = 1`

---

<div class="post-metadata">

**Author:** ![lcs226](https://avatars.discourse-cdn.com/v4/letter/l/848f3c/32.png) [@lcs226](https://forum.inductiveautomation.com/u/lcs226)\
**Post date:** [October 7, 2013, 7:00pm UTC](https://forum.inductiveautomation.com/t/query-returns-cause-field-to-error/7381/3 "2013-10-07T19:00:58Z")

</div>

Thanks,

I had tried that but had my syntax wrong, works great now. 😃