Forum Discussion
MarkShnier__You
Qrew Legend
5 years agoI 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
------------------------------
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__You5 years ago
Qrew Legend
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
------------------------------- GlennPhillips5 years agoQrew TraineeInteresting... 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__You5 years ago
Qrew Legend
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
------------------------------