I am using a table component on a window and populating it by querying tag data from my db. I have several numeric Label components that are using expressions to display min, max and ave values from the table. The problem is that sometimes the data contains null values and the min, max, and ave expressions return the null symbol. How do I ignore the null values in the expressions so that the min, max, and ave are displayed?
By any chance is it displaying NaN? or little square boxes?
These aggregate functions are written to ignore nulls, but on queries that return over 10,000 rows that are all numeric/date, it uses an optimized dataset that turns the nulls into NaNs (“Not a Number”) for efficiency, and the aggregate functions get confused. Is that what you’re seeing?
Yes. I am seeing little boxes.
This has been fixed for 7.2