addting percentage

[kauser]

i have a table and need to change only specific two line items into %. 

Current Output 

Item1	Iteem2
A	45789362.12
B	.4589
C	.8912

Expecting Output- 

Item1	Iteem2
A	45789362.12
B	4.58%
C	8.92%

thank you 

[griffinwelsh · Accepted solution]

@kauser 

1. Convert your data type to string.

2. Filter out the rows you want to convert

3. Use the tonumber and to string functions in a formula to convert the decimal to a percentage and append the % symbol.

4. Union unchanged rows back into your final output.

Note: your expected output is only 10x to convert from decimal to percentage even though it should mathematically be 100x. I used 10x to match your output, but you should double check that this is correct. Solution is attached.