Summarizing Null values

[babaghanoo]

I'm using FM4 and I have a report with no body and 2 sub-summaries. The first summary is a leading one which counts the number of "issues". The second is trailing which counts the number of "articles" within that "issue". The problem I'm having is that null or empty "article" values are included and the count is always 0. For example:

ISSUE 1 ... 5

... 0

article 1 ... 3

article 2 ... 2

How do I configure the report so that null or empty values are not counted?

Thanks for any help.

[LiveOak]

Without knowing what a record is in your database and what fields you have I can only speak in general and take a guess.

If you are using defining a summary field as Count of, all records will be counted. To avoid this you can create a flag field:

Article Flag (calculation, number) =

not IsEmpty(Article Name)

and

Article Count (summary, Total of Article Flag)

This will only count those entries with articles. -bd

[This message has been edited by LiveOak (edited October 11, 2000).]

[Vaughan]

I just go through the database and delete all the empty and invalid records. The task could be automated with a script.