Forums » Help »
Formatting and rounding in decimal fields
Added by Cassia Nino about 8 years ago
Hello,
Is there any configuration about formatting and rounding in decimal fields?
I have this situation:
- There is a field A, decimal
- I edited this value, informing 4.6555
When I visualize the task with that value, I see 4.66 in the field.
If I edit the task, I can see the original value (4.6555).
The problem is that in searches the value is presented formatted and rounded (e.g. 4.66).
If I make a search with the column that presents that value as a result, I'll get wrong values. Especially if I export the data and make a sum.
Can I disable this feature?
It's not interesting change values...
Thanks!
Well, I've found a workaround for this problem.
I created a "text" field, not a "decimal", with a regular expression.
So I have no problems with rounding.
The only problem is how to filter this information like a number...
For example, "where > 50000".
But at least I don't have wrong information.