Truncating a decimal value

[aka_ash]

I am wanting to truncate decimal values to 1 decimal place.

I do not want the value to have rounding applied so ToString() and the Fixed Decimal will not work for me.

Is there a way to this using a formula?

Some sample data and output below:

Data 1
12.123	12.1
0.897	0.8
23.77	23.7
1.55639	1.5
0.23	0.2

Thanks,

Ash

[Qiu · Accepted solution]

@aka_ash 
It is like Round down right?

[randreag]

hi @aka_ash 

I think your best option is create a new field set to fixdecimal 

I hope it helps

[aka_ash]

Thanks @Qiu and @randreag 

The Floor formula rounding down is achieving the truncation i am looking for.

[Qiu]

@aka_ash 

Glad to help and thank you for the accept mark.😁

[aka_ash]

Would it be possible to achieve the same using a Regex formula?

[Qiu]

@aka_ash 

You mean RegEx tool?

[aka_ash]

Hi @Qiu ,

I meant the regex_replace formula, but i can see that the Parse also works, Thanks for that

[aka_ash]

Hi @Qiu.

One thing i did not take account of is negative numbers.

Looks like the Floor formula changes the value of the first decimal as it rounds down, the Regex Parse removes the negative indicator.

Is there a way to get the below?

Data 1	Output
12.123	12.1
-0.897	-0.8
23.77	23.7
-1.55639	-1.5
0.23	0.2
-23.421	-23.4

Thanks in advance,

[Qiu · Accepted solution]

@aka_ash 

Sure