Alteryx Designer Discussions

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

General Discussions has some can't miss conversations going on right now! From conversations about automation to sharing your favorite Alteryx memes, there's something for everyone. Make it part of your community routine!

SOLVED

Need help for number format

alt_tush
8 - Asteroid

Hi Team,

 

I need your help.

 

Can you please help me to format the number 0.999  (It is a fixed decimal)   to  .999 in string format?

 

Exaples

 

Number    ToString (Final result)

 

0.999        .999

12.248      12.248

0.123        .123

 

Thank you in advance.

 

StephenR
Alteryx
Alteryx

I would use the Trim function in addition to the ToString function to trim the unwanted zero.

 

Capture.PNG

 

 

Regards,
Stephen Ruhl
Customer Support Engineer

alt_tush
8 - Asteroid

Thank you for your help.

 

But if I use trim(ToString([Field1],4),"0") formula it convert my 0.9900 value into .99.

I need whole four digit after decimal places.

I.e if my value is 0.9900 then my result value is .9900 not .99.

 

Thank you once again.

 

 

 

StephenR
Alteryx
Alteryx

In that case, use TrimLeft().

Regards,
Stephen Ruhl
Customer Support Engineer

Labels