add percent symbol after calculation in table transformer

[Pham Ngoc Tuong]

i use table transformer to calculate 2 column then result is 3rd column. result show is percent of each one. but how i can add % after number i get in 3rd column.

below is my formular

Round(100.00*T1.'data'/T2.'data2,2), and result , 33.3. i want show as 33.3 % 

[Sanam Malleswari · Accepted solution]

Hi @Pham Ngoc Tuong ,

To show the percent symbol (%) after your calculated result in Table Transformer, you can update your formula like this:

CONCAT(Round(100.00 * T1.'data' / T2.'data2', 2), ' %')

 This will round the result to 2 decimal places and then add the % symbol at the end.
So instead of just 33.3, it will display as 33.3 %.

[Pham Ngoc Tuong]

i can do as well, thank you for your support

[Stiltsoft support]

Hi @Pham Ngoc Tuong ,

As you've mentioned the Table Transformer macro, it means that you use our Table Filter, Charts & Spreadsheets for Confluence app.

So, please refer to our support portal in case of any further questions.