Display numerical field as percentage in a text calculation

[mrswombat]

Hello,

Is it possible to have a numerical field that is referenced within a text calculation display as percent? Right now it will only display as decimal:

My calculation is: If(PO Tax flag="Yes";"Sales Tax @" & Tax::Tax Rate;Resale Information).

Currently the Tax::Tax Rate information displays as "Sales Tax @ 0.0775" and I would like it to display "Sales Tax @ 7.75%". I have to keep my calculation as text so that "Sales Tax" displays and I've tried formatting the Tax::Tax Rate field to display as a percent but of course it only does works in the table it resides in. I feel like there's got to be a quick and simple work around to this but nothing is coming to me. Any other ideas?

Many thanks!

[Lee Smith]

in layout mode, select the field and then in the Inspector, Data >> DataFormatting >> percentage

http://fmhelp.filemaker.com/fmphelp_11/en/html/edit_layout.10.17.html

[Genelia]

Also can use Calculation like:

If(PO Tax flag="Yes";"Sales Tax @" & (Tax::Tax Rate)*100&"%";Resale Information).

it will give you result like "Sales Tax @ 7.75%"

[mrswombat]

Thank you so much! Worked like a charm!! :laugh2: