How to Round number to nearest 2 decimal places

example.

1.12323524123 = 1.12
1.125 = 1.13
1.46832 = 1.47
1 = 1
1.1 = 1.1

Searched in Doc, No real documentation on how to configure this in the Round Function.

Any help would be greatly appreciated :slight_smile:

Thanks,

1 Like

The only limiting factor on decimal places is within a Decimal column’s settings.

well for now i’ve created a virtual column of type decimal and set to 2 places and than use that. But was hoping there was something easier/more compact.

Is what i’ve done the best way?

Really the only way. Outside of using text manipulation, which would still require a VC.

1 Like

To bad, ok thanks.

ROUND( [Decimal] * 100) / 100.0

5 Likes

If you create an Event action with Marc’s formula you can convert it without any additional column.

4 Likes

@Aleksi
Thanks, just needed that. :christmas_tree:

Ahh, interesting :slight_smile:

So Really that is the solution

I had a spreadsheet ROUND formula in an extra column but will try this from @Aleksi

Actually there is a beardtrick.
for example, you got 123456,789 but you bust need 123456,79.

ROUND(123456,789)+ROUND((123456,789-ROUND(123456,789))*100)/100

123456+ROUND((123456,789-123456)*100)/100

123456+ROUND(0,789*100)/100

123456+ROUND(78,9)/100

123456+79/100

123456+0,79

123456,79

Math magic

No.

Way shorter, same result. Not to mention that your expression wouldn’t work in Appsheet because you divided by 100 instead of 100.0.

3 Likes