Forum Discussion

MichaelGraham2's avatar
MichaelGraham2
Qrew Assistant Captain
9 years ago

How do I force a user to ONLY enter up to 2 decimal places?

We have products with unit costs with 4 decimal places but want our sales reps to quote unit price to only 2 decimal places.  Sometimes they forget and use more decimal places and this throws the quo...
Tables and fields
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
Did this not work for you?

IF(Abs([price]-Round([price],0.01))>=0.001,"Too many decimals").  Put that field on the form near the price field and hide the label.

In your case it would be

IF(Abs([price]-Round([price],0.00001))>=0.000001,"Too many decimals").  Put that field on the form near the price field and hide the label.
DanLadner1's avatar
DanLadner1
Qrew Trainee
5 years ago
That does work--though I would have sworn I tried that, I must have bungled it up when trying to account for the additional decimal places. Thanks Mark!