0

# 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!

## 3replies

• Ninox partner
• RoSoft_Steven.1
• 1 yr ago
• Reported - view

You can use the round() function:

round(A * B / 100,2)

• Web_Namer
• 1 yr ago
• Reported - view

RoSoft_Steven

Unfortunately the round function doesn't work.

The number behind the field always contains all decimals.

see attached screenshot.

• Fred
• 1 yr ago
• Reported - view

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