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
Thanks,
Solved! Go to Solution.
If you create an Event action with Marcโs formula you can convert it without any additional column.
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.
To bad, ok thanks.
ROUND( [Decimal] * 100) / 100.0
Thanks Marc. been trying all day to do this. I had to add a step the convert it to decimal first. I'm using it in an appsheet form:
this converts:
18.123456 to 18.12
ROUND(DECIMAL([profit_1]/[Col_valuel]) * 100.00)/ 100.00
If you create an Event action with Marcโs formula you can convert it without any additional column.
@Aleksi
Thanks, just needed that.
Ahh, interesting
So Really that is the solution
I had a spreadsheet ROUND formula in an extra column but will try this from @Aleksi
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.
User | Count |
---|---|
43 | |
26 | |
23 | |
14 | |
11 |