Question Re: Count Group in Technology Q&A

Count Group

Former Member — Fri, 27 Mar 2009 19:05:08 GMT

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.

Re: Count Group

Former Member — Fri, 27 Mar 2009 19:14:11 GMT

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.

Re: Count Group

Former Member — Fri, 27 Mar 2009 21:44:20 GMT

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

Regards,

Raghavendra

Re: Count Group

Former Member — Mon, 30 Mar 2009 09:46:53 GMT

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

Re: Count Group

Former Member — Mon, 30 Mar 2009 12:59:47 GMT

Got it! Thanks for all the ideas and replies.