Rounding weirdness with scientific notation formatString

LabKey Support Forum (Inactive)
Rounding weirdness with scientific notation formatString Jon (LabKey DevOps)  2016-03-02 18:31
Status: Closed
 
Hi Will,

It looks like the number would have to stretch past 5 digits for that number 6 to appear. It's almost like rather than rounding up if you're number to the right is 5 and above, it appears to require two numbers to the right since the format 555.6E-3 appears if you make the original number at 0.555551 through 0.555559

Let me verify whether this rounding is intentional by LabKey or by the DB.

Regards,

Jon