Forum Discussion

MichaelGraham2's avatar
MichaelGraham2
Qrew Assistant Captain
11 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
DanLadner1's avatar
DanLadner1
Qrew Trainee
7 years ago
I'm trying to implement similar logic, but limiting the user to 5 decimal places, rather than just 2. There seems to be some limitation with QB formulas/functions, based on the length (that is, 5 vs 2), that I can't quite wrap my head around. Is anyone able to implement this logic successfully?