Forum Discussion
MarkShnier__You
Qrew Champion
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
------------------------------
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
4 years agoQrew Trainee
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
------------------------------
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
------------------------------