community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Need help for number format

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.

 

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

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.

 

 

 

Alteryx
Alteryx

In that case, use TrimLeft().

Regards,
Stephen Ruhl
Customer Support Engineer

Labels