Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

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

After Decimal Keep All Zeroes till a number greater than 0 is found

Pankaj_G
7 - Meteor

Hi, I am looking for a solution for below given problem.

 

If i have a number which is 0.00000000458393 and a number 0.0056898 Then in both cases i want to keep all the zeroes after decimal till a number greater than zero is found after decimal, And once a number is found than i want to keep only two numbers, a few examples are given below

 

0.0000000435638 to 0.000000043

 

0.0008989 to 0.00089

 

Thanks in advance for the solution

2 REPLIES 2
Emmanuel_G
13 - Pulsar

@Pankaj_G 

 

In attachement one way of doing that.

 

Let me know if there is any issue,

 

Emmanuel_G_0-1664887082238.png

 

binuacs
21 - Polaris

@Pankaj_G One way of doing this

binuacs_0-1664887649112.png

 

Labels
Top Solution Authors