Forum Discussion

GlennPhillips's avatar
GlennPhillips
Qrew Trainee
5 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
Icon for Qrew Legend rankQrew Legend
5 years ago
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
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
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
    5 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
      Icon for Qrew Legend rankQrew Legend
      5 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
        5 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
        ------------------------------