This content has been marked as final. Show 2 replies
I have a query which may return no results as below:
LOAD Count(ProductID) as Critical
WHERE UnitsInStock <ReorderLevel
I display the Critical on a Gauge (Led) and when no result return from the query the Gauge dissaperas where I would like to show the number 0.
Also I tried to show the result of Critical on a Listbox to check if it is null or not nothing came up,
Briefly my question is; how can I show the result as 0 when there is no results?