expression needed to round number

how do i round number 6,879 to 6,88 ?

i know only that expressions:

floor

round

ciel (dont work)

is any other to use??

Maybe the answer is to easy:

x= 6,879

round(x*100)/100

The actual expression is spelled "Ceil()" and it will round to the upper integer.

In doubts always refer to the system expressions manual article.

Asmodean formula is the best answer for your actual question.

Asmodean that works perfecct

Kyatric and is Asmodean are both correct.

Ceil() is great for rounding up integers while floor() is great to round down integers.

Take your value x and use (floor(x*100)/100), granted round will do the same in this example; but floor is better for if the number has lots of decimals.

—: Indeed floor() has an impact on the number of decimals.

But it also impacts the result, whether the last decimal is greater than 5 or not, when using "floor" the returned number will always be rounded down, whereas "round" allows to have a distribution in both direction (down if the last decimal is less than 5, up if it is 5 or more).

To impact on the number of decimals you want, modify the value "100" to bigger, depending on the decimals you need.