Skip to main content
Question

Large Number Rounding Up Past 10 Million

  • November 27, 2019
  • 0 replies
  • 71 views
Forum|alt.badge.img+2
Hi,

I am making a rich text formula field to display a numeric summary field.

When the number is 1,000,000.50 it converts identically.
When the number is 10,000,000.50 it rounds up the .50 to 10,000,001.

Is there a simple way to stop this from happening? or this just a Quick Base limitation?

I have tried using a solution from another post: ToText(Round([Currency], 0.01))
but this did not work unfortunately.

My only other thought would be to build an if statement to subtract extra zeros when the number exceeds an amount and use a Right() function to pull the decimal places from that number since it wouldn't round up. Not ideal.

Any help would be greatly appreciated!

Regards,

------------------------------
Curtis Middleton
------------------------------
This topic has been closed for replies.

  • EvanWestbrook
  • Quickbase Alumni
  • November 27, 2019
Curtis,

I don't have an answer for you, but I found some additional information. Maybe someone from the QuickBase team can help clarify because I'm curious about this, too.

  1. QuickBase Function documentation does mention there are some issues inherent with rounding and floating point numbers
  2. I replicated your problem with a hard coded number. When my number when from 1,000,000.50 to 10,000,000.50, QuickBase actually changed my formula. Check it out below:


------------------------------
Evan Westbrook
PRIME Developer
Harder Mechanical Contractors Inc.
Portland OR
------------------------------
Terms & ConditionsAccessibility statement