Forum Discussion

GlennPhillips's avatar
GlennPhillips
Qrew Trainee
4 years ago

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

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 alph...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Qrew Champion
The bug I'm seeing is when you round to zero places.  The other rounding seems to work so far.

I tried to put in a support case but the support site won't load for me. 


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
GlennPhillips's avatar
GlennPhillips
Qrew Trainee
4 years ago
Interesting...  I did confirm FLOOR has same issue, gives the exact same wrong answer. I did not test CEIL but I bet it fails too.
So, based on the info you provided, I found I can force by numeric percentage calculation from the error of..

Round(0.251, 0) = -1.#IND0000% (but should be 25%)

to work IF I "game it" like this...

Round(0.251 * 10, 0.01)  /  10 = 25%

So that confirms what you noticed Mark about the zero places. Thanks, that was helpful so now I'm pondering if I patch my formulas to keep us working until Monday or if someone will see this and the tickets over the weekend, even if it is the deployment team. 

The hard part of that is that I don't know an easy way to search all my formulas fields for a single  specific function (does anyone know such a method?)

As far as a cause, I wonder if they pushed a library out in advance of the code update coming?
G


------------------------------
Glenn Glenn
------------------------------
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    4 years ago
    It could be that rounding to Round([Myfield] ,0)   .. is not a supported use of the round formula.  ie the zero may not be documented as supposed to work.  I'm not sure, but I likely too would have done that when Round([My field would have worked to round to integer.

    So in terms of panic, it's just where you were rounding to zero places and used the ,0  in the function.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------
    • GlennPhillips's avatar
      GlennPhillips
      Qrew Trainee
      4 years ago
      Hi Mark, well, it may be that rounding is not supported that way, but it has worked for years for us as written, so something did change besides our code.

      In terms of panic, the trick is to find all the places we use this function so we check how it is written. It may not be many places, and we could go through all the formula fields one-by-one, but we may have 300 formula fields, and some are lengthy.  I could likely do it in an hour I suppose, and probably should, but if it is a QB bug I just bugs me to spend the time.  

      We have one table with a very complex form that really has outgrown what Quickbase will do, but we're updating it to buy time, as the replacement of it with a more robust software would be a very expensive project and take months to complete correctly.

      Appreciate you for looking into this and your observations!! G

      ------------------------------
      Glenn Glenn
      ------------------------------