Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to get count of "OnTime" records 1

Status
Not open for further replies.

capronton

MIS
Jun 28, 2013
159
US
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
 
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
 
@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.
 
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!
 
The point, my friend, Dana's started 20 threads and posted 23 "thank You" votes.

You have started 20 threads: that's all.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top