Count Group

[#1]

I have a report Grouped by Work Order number. How do I do a count on the group? Right clicking and inserting a summary is not an option on the group. Any help will be greatly appreciated.

[Former Member · Accepted solution]

Hi Brent,

Try this:

In the Field Explorer, right click on Running Total Fields -> Click New -> Give it a name -> choose the work order number as the field to summarize -> type of summary should be count -> Evaluate for every record -> Reset On Change of Group and choose the work order number group from the drop down menu -> click OK.

This will give you a count for each grouping.

I hope this helps.

Regards,

Zack H.

[Former Member]

Hi,

Try this way.

create a formula field and place the following code

COUNT({Command.COURSE}, WorkOrderNumber)

Place this formula field in Group Header.

Regards,

Sathish

[Former Member]

Got it! Thanks for all the ideas and replies.

[Former Member]

Try using the special field in the field explorer "GroupNumber"

Regards,

Raghavendra