How can I keep data up to 2 decimal point

Question

Hello: Great people. How can I keep data up to two decimal point?

Difference

V_String 
0.480000000010477
0.239999999990687
-0.160000000003492
-0.159999999999854
-0.159999999999854
-0.30000000000291
0.479999999995925
-0.30000000000291
-0.220000000001164

-0.160000000003492

Thank you

FinnCharlton · Accepted Answer

Hi @Kinetic_analytics ,

Here is how to round these values to 2.d.p, while keeping as a V_String:

Hope this helps

davidskaife · Accepted Answer

Hi @Kinetic_analytics

Assuming you're wanting to keep the field as a V_String you could do this on the Difference Field:

or when calculating the difference wrap the formula in Round([calculations],0.001) - as long as the output is a numeric data type