Count Function

[Plucky]

Hi I have created a field called "Turnaround" that lets me know when a job was required.

I would like to show in a summary how many jobs were:

Same Day

Next Day

2 Day

3 Day

4 Day

I have created a field called "Same_Day_Count" and would like to have a Count Calculation that only counts the Same Day's in the Turnaround field.

Any ideas?

[IdealData]

The Count function can work on related fields - so set up a relationship with the match criteria you have described and use the Count function on the field from that relationship.

You have provided an effective distinction between the "days", now all you need are the relationships that will allow the Count function to work on the appropriated relationships.

[IdealData]

You're right LaRetta - completely mis-read it - IGNORE MY POSTING.

[Plucky]

Thanks for the reply's.

I have ended up creating a calc field for each result like this

If ( AW_TurnAround_SameDay = "Same Day" ; "1" ; "" )

and then created it's own summary field with a total of AW_TurnAround_SameDay.

It took 14 fields but I got there in the end.