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
Solved! Go to Solution.