Percent Problems, PLEASE help!

[Bob Westfield]

I'm using FM Pro 5 Unlimited and am trying to serve the data using FM WebServer Assistant. So far so good.

The problem comes when I try to display my some of the data. I've converted data in FMPro to display percentages. I've then used HomePage to generate the html and cdml tags for the page.

Unfortunately, the data displays as decimal type, not percentages. (Though the database is displaying percentages)

Can someone please help me? I've done everything I know to do, but it still displays in html as decimal data.

I convinced my boss to go with Filemaker over another product and my head is hanging in the balance over this.

Thanks in advance for any help.

------------------

-Bob

[beltro]

One workaround to your problem is creating a calc field. I would simply multiply the number by 100 and add "%". calc would be something like percentfield*100 & "%"

put the calc field on the web instead of the original field. Filemaker formatting does not get pushed out to the web and you are using FM formatting to show it as a whole percentage (like 25% instead of .25) but in the field it actually has the number as a decimal.

I hope that clears things up and actually helps.

Beltro

reorderReport.fp7.zip

[skoontz]

Do not bother with a calculation within FMP. Use the new tag 'format' after the field. For example: [fmp-field :pct, format]. Do NOT use Claris Home Page to add this option unless you turn off any abilities for HP to modify your code. HP does not recognize the 'format' tag and removes it.

[This message has been edited by skoontz (edited September 09, 2000).]