How to get count of "OnTime" records 1

[capronton]

How can I get total count of "OnTime" records? See dataset below:

tDate incTime schTime bus rsaStatus service
1/6/15 11:23:29 11:22 7417 OnTime WKDAY
1/6/15 10:02:06 10:02 2023 OnTime WKDAY
1/6/15 10:11:44 10:12 2023 Early WKDAY
1/6/15 10:17:10 10:18 2023 Early WKDAY
1/6/15 10:41:28 10:43 2023 Early WKDAY
1/6/15 10:48:06 10:49 2023 Early WKDAY
1/6/15 11:00:54 11:01 2023 Early WKDAY
1/6/15 11:26:16 11:26 2023 OnTime WKDAY
1/6/15 11:33:44 11:36 2023 Early WKDAY
1/6/15 11:46:14 11:36 2023 Late WKDAY
1/6/15 11:48:34 11:42 2023 Late WKDAY
1/6/15 12:53:04 12:50 2023 OnTime WKDAY
1/6/15 13:03:00 13:00 2023 OnTime WKDAY
1/6/15 13:09:38 13:06 2023 OnTime WKDAY
1/6/15 13:39:52 13:31 2023 Late WKDAY
1/6/15 13:45:06 13:37 2023 Late WKDAY
1/6/15 13:56:28 13:49 2023 Late WKDAY
1/6/15 14:15:28 14:12 2023 OnTime WKDAY
1/6/15 14:25:18 14:24 2023 OnTime WKDAY
1/6/15 14:31:20 14:31 2023 OnTime WKDAY
1/6/15 15:01:52 15:02 2023 Early WKDAY
1/6/15 15:07:52 15:08 2023 Early WKDAY
1/6/15 15:20:48 15:21 2023 Early WKDAY
1/6/15 15:44:40 15:42 2023 OnTime WKDAY
1/6/15 15:54:10 15:54 2023 OnTime WKDAY

 

[ianoctdec]

Hi,

Create a running total: count of rsaStatus, evaluate on condition rsaStatus = 'OnTime'

or

create a formula:
@StatusFlag
if rsaStatus = 'OnTime' then 1 else 0
inser a summarry on this formula

Dana

 

[SkipVought]

@capronton, you got a good tip. How about thanking Dana, and a little purple star would also be appropriate.

You seem not to have done this any time during your tenure here at Tek-Tips either.

 

[capronton]

SkipVaught,

I usually do say thanks at some point in the "Thread". But if I neglecting thanking you, please accept my Thanks and Appreciation for all the help you given me over the years.

Thanks Dana again, this is very helpful!

 

[SkipVought]

The point, my friend, Dana's started 20 threads and posted 23 "thank You" votes.

You have started 20 threads: that's all.