Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
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?
Jon
hI
Num(sum [value]),'# ##0.00 %')
NO NEED TO DEVIDE BY 100
THANKS
michale
Hi Jon,
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,
Num(Expr1,'Copied Format')