Displaying a number as a percentage in a list

[githinji84]

Hi guys,

Sounds simple but I can't find away to display a number (saved as a float in the table) to display as a %. e.g. 0.025 to be displayed as 2.5% in a list.

Can someone help?

Regards
Simon

 

[cheesegrits]

Best way is probably with a calc to actually display what you need.

return sprintf('\%%.2f', '{yourtable___yourfloat}');

-- hugh

 

[githinji84]

Thanks. I converted to Calc, Now it is working