I have a number field which has a value of "10" in one record. This represents the tax rate. i.e. 10%.
I would like to display this number as a percentage, but when I add the percentage formatting option via the Inspector it is showing as "1,000.00%".
I realise I can change the value to "0.10" to get it showing as 10%, however this number is coming from an external vendor system automatically so I cannot override this. Is there a way to keep the value as "10" but have it display as 10%?
I would like to avoid creating a new calculation field if possible.