GetAsText - percent

[enquirerfm]

I have a field which I have set up as a calculation to pull in data from several fields - it is designated as a text field. One piece of data I want is numeric - contains a percentage. In the original field it is set up as a number which present itself as a one decimal point percentage e.g. you have to key in .125 to arrive at 12.5% as it is reprented in the originating field. Now, if I use GetAsText in my new field I obtain 0.12. If I use GetAsNumber it is also 0.12. How can I obtain 12.5% ? Thx.

[comment]

Try =

YourValue * 100 & "%"

[enquirerfm]

Yes, this works great - should have thought to do this. Is there a way I can omit a result when it would otherwise show 0%?

[comment]

Case ( YourValue ; YourValue * 100 & "%" )