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.&nbsp; It breaks an important form we use 7 days a week.&nbsp; I submitted a ticket to QuickBase, but in the past they did not respond on weekends.&nbsp; Kinda puts us in a bind.&nbsp;Anyone else seeing this issue?Thanks,
Glenn------------------------------Glenn Glenn------------------------------

markshnier__you · Answer

I cannot duplicate that result, but when I do your formulaRound(.251,0)I get minus 1ie-1.. which is not correct.If I just do Round(.125)&nbsp; 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.&nbsp; 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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

markshnier__you · Answer

The bug I'm seeing is when you round to zero places.&nbsp; 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.&nbsp;------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

glennphillips · Answer

Interesting...&nbsp; 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)&nbsp; /&nbsp; 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.&nbsp; The hard part of that is that I don't know an easy way to search all my formulas fields for a single&nbsp; 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 · Answer

It could be that rounding to Round([Myfield] ,0)&nbsp; &nbsp;.. is not a supported use of the round formula.&nbsp; ie the zero may not be documented as supposed to work.&nbsp; 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&nbsp; in the function.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

glennphillips · Answer

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.&nbsp; 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.&nbsp;&nbsp;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------------------------------

Forum Discussion

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

Related Content

Why no Reply-To Header Functionality?

Accessing previous field values after an import mapping failure

Nz Function - Formula Help

Pipeline Failure Notification

Do unused tables related to currently used tables cause functionality problems?