Overnight Failure of ROUND and FLOOR Function... Anyone Else???

Question

The ROUND and FLOOR functions no longer return valid numeric values.Last night (6pm Central Time US 2/5/2021) these were fine. This morning, Saturday 2/6/2021 at 8am they return numbers with alpha-characters in the them.I stripped my formula down to confirm that it is an issue with the QuickBase function and not my code.When my formula is only the number:.251the result is correctly:25.10000000%When I change the formula to:Round(.251,0)the result is incorrectly:-1.#IND0000%The problem is repeatable across multiple forms and fields.  It breaks an important form we use 7 days a week.  I submitted a ticket to QuickBase, but in the past they did not respond on weekends.  Kinda puts us in a bind. Anyone else seeing this issue?Thanks,
Glenn------------------------------Glenn Glenn------------------------------

MarkShnierYou · Answer

I cannot duplicate that result, but when I do your formula
Round(.251,0)

I get minus 1

ie
-1

.. which is not correct.

If I just do Round(.125) get 0 which is correct.

The default behaviour of Round is to round to zero decimals if the second parameter is omitted, but I do agree that there is something weird going on with round. Its pretty odd since you would think that there is a risk of bugs at a release, but the new release is tomorrow, not today.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community