
January 11th, 2005, 10:26 AM
|
|
Registered User
|
|
Join Date: Jan 2005
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Negative Sum result in Reports
I'm not completely new to this but formulas and I have never gotten along well. I have a report that retrieves it's information straight from a table. I placed a type header and footer in the report and have it divided into categories. From there I have it subdivided into types, so it looks like this
Report Header
Page Header
Type Header
Status Header
Detail
Type Footer
Page Footer
Report Footer
The Status Header key's in on the a secondary key field in the table that is linked to the primary key of another table. It is told to display the Status and then count how many records have that status using the following code
=count("StatusID")
It does this well but places a "-" minues sign before the results. I don't know why it is doing that or how to get rid of it. The Type footer performs a similar count with the same "-" appearing in the result.
How do I get rid of the "-"?
|