Hello, I'm trying to round my data down to the first decimal. My data looks like the below: UserValueDesired Result11.231.221.251.231.271.2 I've tried using the floor function, but that rounds to the nearest integer. The round function also does not give me my desired result as it round based on 0.5. Thanks! Julian

Rounding Down to first Decimal

Hello,

I'm trying to round my data down to the first decimal. My data looks like the below:

User	Value	Desired Result
1	1.23	1.2
2	1.25	1.2
3	1.27	1.2

I've tried using the floor function, but that rounds to the nearest integer. The round function also does not give me my desired result as it round based on 0.5.

Thanks!
Julian

Workflow

Tips and Tricks

Preparation

Accepted answers

myastarling

The other thing you can do is multiply it by 10, take the floor, and then divide it by 10. That way, if the decimal goes out to additional places, then it will still round to tenths.

(floor([Field2]*10))/10

All comments

StephenRuhl

I would convert it to a string and take Left([Value], 3), then you can convert it back to a number.

myastarling

The other thing you can do is multiply it by 10, take the floor, and then divide it by 10. That way, if the decimal goes out to additional places, then it will still round to tenths.

(floor([Field2]*10))/10

ponraj

I would recommend you to use select tool with configuration set to Type:Fixed decimal and Size 19.1

mbooker

I found that (floor([Field2]*10))/10 worked correctly but "Type:Fixed decimal and Size 19.1" actually rounded up 1 item in my data set!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703