Elimination of decimal numbers
Hi!
How can I remove decimal numbers from a number?
I have a Number field which is set to Euro currency with two decimals.
But during the calculations what is behind it is considered, i.e. a number with more decimal places.
How can I make Ninox use only two decimals for calculations?
I give an example
I have an "A" Numero field where this amount in euros is entered: 12.00
I have a "B" Number field where a number representing the tax is entered: 26.7
Formula I have a field "C": A * B / 100
The visual result in field C is 3.20
The result behind the field is 3,204. In this case the final digit "4" causes me difficulties because when I use the field C in other formulas it will be taken into consideration, undoing the calculations.
How can I eliminate the digit 4 (therefore tell Ninox that even behind the field it has to consider only 2 decimals?)
Thank you!
3 replies

You can use the round() function:
round(A * B / 100,2)

RoSoft_Steven
Unfortunately the round function doesn't work.
The number behind the field always contains all decimals.
see attached screenshot.

You can use the round() function inside of your formulas. So if need to use C in another formula you can do:
round(C,2) * somethingElse
Content aside
 1 yr agoLast active
 3Replies
 82Views

3
Following