ROUNDUP expression

[paulogeneroso]

Hello everybody!!!

I'm needing a help. I want to make a ROUNDUP expression in a field with numbers.

How to do that??

Tks in advance,

Paulo

 

[gemma-the-husky]

do you mean 12.1 needs rounding up to 13

if so then if its an integer do nothing, otherwise, add1 and round down(truncate)

 

[IgorB]

Just use buit-in function Round(yourexpression,2)
This example will round up your number to 2 decimal points.

 

[gemma-the-husky]

yes but round will round down and up, depending on the value. if the poster wants the value to ALWAYS round up, you need to do something different