How to keep the trailing zeros after decimal point?

So my Alteryx output truncates trailing zeros after decimal point which makes it difficult for me to apply string operations like add "%"

So something like this:

Alteryx Column

38.5

23.75

Current Output by adding "%"

38.5%

23.75%

27%

Desired Output

38.50%

23.75%

27.00%

Transformation

Preparation

Expression

Accepted answers

tom_montpool

This sample uses the example values you gave in your first post.

kunjanp.yxmd

All comments

ddye

Use the select tool - Change type column to Fixed Decimal - Change the number to the right of the decimal in the Size column to fix the number of decimal places you want to show.

Believe that should work.

Cheers.

tom_montpool

Changing the data type to Fixed Decimal n.2 will definitely fix the decimal place side of your question, however, you can't add the "%" symbol to the Fixed Decimal value.

To include the "%" symbol, you don't actually have to convert to Fixed Decimal first, instead you would need to create a new string field using:

ToString([ExistingField],2)+"%"

If you look a the help entry for the ToString Conversion function (https://help.alteryx.com/10.6/index.htm#Reference/Functions.htm#Conversion_) it shows that you can specify two parameters other than the field name:

ToString(x,numDec,addCommas)

Of course, if you have a ton of fields to do this on, use the Multi Field Formula tool.

kunjanp

I chose 19.2 fixed decimal but that truncates the trailing zeros after decimal point

Quick Links

This months top contributors

AkimasaKajitani 389

mceleavey 388

mbarone 337

michael_weaver 335

Hollingsworth 335