Query returns cause field to error

Ignition
1

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?

2

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

3

Thanks,

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