Hello Ignition Forums,
Not sure what's going on here but trying to calculate the standard deviation of a column of numbers from our db. In this case, we are returned with this
All the numbers that the standard deviation calculation is being done on are the same so the standard deviation should be 0 but Ignition gives me a value close to 0 but not completely.
When calculating the value we need, this only happens when the columns values are all the same. I have noticed that other collections seem to give the correct standard deviation but when they are all the same it does not.
(same code different numbers)