Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Truncating a decimal value

aka_ash
8 - Asteroid

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.12312.1
0.8970.8
23.7723.7
1.556391.5
0.230.2

 

Thanks,

Ash

10 REPLIES 10
aka_ash
8 - Asteroid

Thanks again @Qiu,

 

The update works for me, appreciate your help on this.

Labels
Top Solution Authors