Hi all need a little help here.
I am using a Numeric Text field to display values but
I always get this error if the result is null, even I have tick the Fall back Value and set to 0
Exception: Conversion error: query returned null, binding needs “double”
on query binding for “StdUnit_Chart.Root Container.Container Chart.Container.Numeric Text Field 2.doubleValue”
This is my query:
SELECT
Sum(Scrap)
FROM Ignition_database
where Machine = ‘10’ and [Date] = ‘2017-07-10’
Does somebody has a work around for this or is there something that I am missing?