i have a table and need to change only specific two line items into %.
Current Output
Expecting Output-
8.92%
thank you
@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.
