For some reason on my record it has 4 or 5 decimal...
# suiteanalytics
s
For some reason on my record it has 4 or 5 decimal but on the saved search it only displays two for planned standard cost. On the item search it shows even 8 decimals
c
I think if you choose Amount in the result it by default goes off currency format which is no more than 2 decimal places. If you want to show all of the digits after the decimal place, try using Formula(numeric) and {amount} as the formula and see if that works (or whatever field you're trying to use). Only thing is that if the number is say 14.40, doing this will drop the zero, so you might have some results that show just one digit after the decimal.
s
Thanks that’s little better than 2 but it’s still random, some has 2,3,4 precision (no.after the decimal)
cost is what I had intially, Formula Numeric gave me the second column
c
Formula(numeric) drops any zeros after the digit
and looks like cost rounds to two decimal places. That .07676 number is likely the true number entered on whatever record it was from. The cost version of that number rounds it to .08
s
I think it did the trick, Thank you.
message has been deleted
c
Awesome
a
You can also use formula numeric: Round({amount},number of decimal places) e.g. Round({amount},4)