Displaying figure in text box as %

[hopkinsc]

Hi all,

I have the following expression in a text box:

sum  ( {<[Stock Movement Reason Code] ={3, 5}>} StockQty)/Sum({$<[Stock Reason]=, Dept-={'U'}>}SalesValue)

Can someone tell me how i can display this a % please?

[jedgson · Accepted solution]

place the following around the above code:

num( <expression>, '##.00%')

Remove or add the zero's after the decimal depending on the accuracy you need.

Jay

[#3]

Hi Chris

use num function where you can specify the format , like this :

=num(your expression, '0.00 %')

Regards

Gilles

[hopkinsc]

Thanks both, they both worked..