In the below table, the % Paid
column is a formula column that divides Price
and Amount Paid
.
The formula I am currently using for the % Paid
column is:
([Amount Paid]/[Price])*100
While the resulting % Paid
shows the correct data, I would much prefer if it would display just one decimal with a "%" after the data. (Adding a &"%"
to the end of the formula does not work on SmartSuite.)
Does anyone know how I can achieve this? Appreciate your help.