Adding % with Fixed Decilam format

[kauser]

hello, 

i am using Fixed format(19.3) to change my value  from 0 to 0.000 and now i need to add % sign after three decimal number. i want to see my output as below 

Current Output:

Quarter

0

0

0

Expected Output:

Quarter

0.000%

0.000%

0.000%

Thank you 

[ChrisTX · Accepted solution]

You'll need to convert the data type to String, then add a "%" character.

Check out the Conversion Functions (alteryx.com), like ToString

Chris

[DataNath]

Hey @kauser, in order to add the '%' sign, you'll need to store this field as a string instead. You can do this, as well as adding the decimals, in a Formula expression using ToString() - one of the arguments allows you to define the number of dp:

ToString([Quarter], 3)+'%'

[KamenRider]

Here's my solution