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

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 %.