Severe Division with Decimals


#1

I have an array with numbers such as:

0.000151253873
69.682443
1.30265
1616
660.75
2976.590426

In an array filter, I need to divide a number such as 1.30265 (ideally rounded to 1.303) with each one. It’s working, but too often I’m getting a scientific notation in the result versus a number that needs to be no more than 3 decimal places.

For example: 1.303/208.105 = 6.26126234352851e-3
The result I want is 0.006

I’m using pattern( to trim the decimal to 3 places up front and have tried every float I can imagine on the division. Is there a way to do this?


#2

Use the pattern on the result:

pattern(1.303/208.105,"#.###")

#3

That’s about the only thing I didn’t try.

Thanks, it works.