Negative numbers not showing in IWP

[Tom Davey]

I am using Filemaker 10 on two Macs and a third Mac views a simple report from a web browser thru IWP (one of the Macs acting as the server but is FMP10 Advanced, not FMP Server). One of the fields in the report contains a negative number. The field is a number imported from a text file, not a calc.

When viewing in FileMaker, it appears as a negative without a problem. However, IWP seems to strip the negative sign out before displaying. I've tried changing the font and putting it in parenthesis instead of a negative sign. I even tried conditional formatting to change the color if it's < 0 but it doesn't work. It looks like IWP thinks it's a positive number.

I've searched the web but can't find out a way around this. I've also accessed the report from Safari & FireFox on the Mac and IE on Windows but none show the negative sign. Has anyone seen this before?

Thanks,

Tom

[IdealData]

Just tested okay on FMPA 10.0.3/Safari Version 4.0.4 (4531.21.10) - are you on the same version of FMPA?

[Tom Davey]

Thanks for the quick reply. Yes, I am running 10.0v3 of FMPA. Interestingly, I just noticed that if I change the number format to general and not decimal, it's fine. Seems like the formatting is doing it. I experimented with the different decimal options but none seem to fix it, only setting as general works (which is not an ideal format) in this case. Bizarre. Will test on another FMP machine to see if it does the same thing when sharing the file. Thanks again.

[comment]

I would suspect the problem is with your data. What do you get if you open Data Viewer and look at:

Sign ( YourField )