glgene
616 posts
msg #95576
- Ignore glgene |
8/11/2010 3:00:38 PM
I'm trying the new ROUND function, but am not getting the desired results.
Here is the SF instructon:
round (indicator, decimal offset) It rounds to nearest value based on decimal offset.
Here is my simple, attempted script:
I get only 2 decimal places in the add column line. I want 4 decimal places.
???
|
Kevin_in_GA
4,599 posts
msg #95578
- Ignore Kevin_in_GA |
8/11/2010 3:07:01 PM
Do you really need 4 decimal places? Honestly?
The RSI values are in all likelihood rounded to two decimal places, so you cannot be more precise than this, even if you are taking a ratio. The round off error in the inputs is what matters, not the ratio.
|
glgene
616 posts
msg #95580
- Ignore glgene |
8/11/2010 3:50:16 PM
Kevin,
I don't really need 4 decimals in this case (RSI). This is just an example only. My example is flawed, that's why I am seeking a solution. SF says you can specify the number of places to the right of the decimal. ???
Thanks.
|