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!

3 replies

null
    • 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