I have a calculation insetrted a bit of active text in a text object .
How do I format these numbers to display as a % with two decimals as currently the result of the calculation shows as an unformatted number with decimals up to anbotu 10 places?
Num(sum [value]),'# ##0.00 %')
NO NEED TO DEVIDE BY 100
First decide your output format using any of the chart properties number tab and copy that formatting come to text oject and paste like this,
Retrieving data ...