Convert number in percentage and alignment of table

[Rajesh_27]

Hello Alteryx community,

I have few numbers which i would like to convert to percentage (% of Total Liquid) this is already percentage in the excel but in alteryx its showing as number. Second point on which i need help is i am trying to align both the tables (Balances and & of Total Liquid).

Thank you for your assistance.

[dkma]

you would need to use concatenate '%' symbol with the number, and make it to string format. 

and to get the tables side by side, you'd need to set up the configuration as below.

give this a try

[binuacs]

@Rajesh_27 use the suffix option in the Table tool to concatenate the % with the amount

[Rajesh_27 · Accepted solution]

Hi Binuacs,

thanks for the help, just realized how stupid i am :)

is it also possible to guide me on how to align the tables please, or changing the table settings (width, fixed) only possible solution?

[binuacs]

@Rajesh_27 you need to use the layout tool to adjust the table width. Let me know if you need any additional information