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?