Count Formula

[peterpater]

Hi:
I have a Flag field which is either "Y" or "N".
The other fields are:
- Date
- Category
- Topic
- Flag ( Y or N)

Group 1 is Date, Group 2 is Category and Group 3 is Topic.

I am trying to count the number of Ys in a Category but I am unable to do so as I am getting errors. Any suggestions would be very helpful.

Thank you.

 

[cjbrown815]

create a running total summarize count on flag field/evalute all records and reset on category

-CJ

 

[cjbrown815]

I'm sorry, on the evaluate section use formula
{Flagfield}="Y"

-CJ

 

[lbass]

You could just write a formula:

if {table.flag} = 'Y' then 1

Then right click on this formula in the detail section and insert a sum (not count) at the category group level.

-LB

 

[tdavis72]

Help,

I need to create a report that counts a displays the number of employees that have been terminated yeart to date and monthly. My issue is how do I set the fiscal date to October 01, 2005 to September 30, 2006? I can find any kind of formuala that will allow me to do this.

 

[lbass]

tdavis72--Please start a new thread as your topic is unrelated.

-LB

 

[peterpater]

Thanks a lot folks. It works.