Using the Count Function

[agreen10]

I am trying to use the count function to count the number of times a report prints "below average" or "above average"
I would like it to be like a summary of a field and show up in the grand footer section of my report. What is the best way for me to handle this.

 

[synapsevampire]

Please try to post technical information, such as how this "below average" is being displayed, and I assume that you don't really mean how often it's being printed.

If it's a field, then use the count function, if it's text somewhere, then you'll need a formula with a variable to count it:

numbervar MyCount;
MyCount:=MyCount+1

Place this next to tyhe text object.

Then in the report footer use:

numbervar MyCount;
MyCount:=MyCount

There is no such thing as a grand footer.

-k

 

[lbass]

You could try using a conditional formula like:

if {table.string} = "Below Average" then 1

Make a similar formula for the other text. Then right click on each formula and insert a summary (grand total), using SUM, not count. If this is accurate, then you're all set. If the number is inflated, you'll need to use a running total that takes into account duplicate fields.

-LB