Guys,
Need your help please. I won't explain the boring reasons, but the workflow is as follows;
I need numbers that are currently 6 decimal places, but only the first 3 decimal places are to be used, specifically as shown to the user when formatted to display 3 decimal places.
Example
So, we have currently, 0.590487. I want to use only 0.590.
I have used TRUNC, which works on that number. However on a number showing as 0.493, but is actually 0.492733, its giving me 0.492 when TRUNC'd - when I want to take the 0.493.
TL;DR - I want to truly copy and paste the 3 decimal place numbers in a list as SHOWN, without consideration for the 6 decimal place behind it. TRUN does not work as I would like.
Hope I have explained that correctly!
Need your help please. I won't explain the boring reasons, but the workflow is as follows;
I need numbers that are currently 6 decimal places, but only the first 3 decimal places are to be used, specifically as shown to the user when formatted to display 3 decimal places.
Example
So, we have currently, 0.590487. I want to use only 0.590.
I have used TRUNC, which works on that number. However on a number showing as 0.493, but is actually 0.492733, its giving me 0.492 when TRUNC'd - when I want to take the 0.493.
TL;DR - I want to truly copy and paste the 3 decimal place numbers in a list as SHOWN, without consideration for the 6 decimal place behind it. TRUN does not work as I would like.
Hope I have explained that correctly!
