Use a calculation with the round function to round the value to 3 places. This could be the same calculation field that you mention above or a field added to the table for export purposes depending on whether you need the unrounded result for other purposes or not.
That does not work.
The last line of my calculation is
Round (Result, 3)
which is giving a result of 0.21 in one instance and 0.166 in another.
I can use the formatting of the field to get it to look like 0.210 but when I export the record 0.21 is exported and not 0.210.
3 of 3 people found this helpful
Screen format (decimal, 3) is what you want, then export with "Apply current layout's data formatting" option on bottom-left of export screen.
Thank you! That did the trick!