Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

How can I keep data up to 2 decimal point

Kinetic_analytics
11 - Bolide

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

4 REPLIES 4
FinnCharlton
13 - Pulsar

Hi @Kinetic_analytics ,

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

FinnCharlton_0-1674749949500.png

 

Hope this helps

Kinetic_analytics
11 - Bolide

@FinnCharlton  Thank you for helping me in my learning process.

davidskaife
14 - Magnetar

Hi @Kinetic_analytics 

 

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

 

DavidSkaife_0-1674749926221.png

 

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

Kinetic_analytics
11 - Bolide

@davidskaife Thank you for the tips. I got bonus tips from you. Appreciate your time, knowledge, and help. 

Labels
Top Solution Authors