AnsweredAssumed Answered

Formatting Number as Percentage

Question asked by fmdataweb on Feb 25, 2015
Latest reply on Feb 25, 2015 by keywords

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.