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!

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

Counting Blank Fields

Status
Not open for further replies.
BrickMad

BrickMad

Technical User
May 2, 2003
2
NZ
I have a field with the time of day in it, however I want to count this field when the time of day has not been added , any ideas?

Thanks
 
Sort by date Sort by votes
Perform a record count (like on the PK) and a count on the specific time of day field.
The difference should be the number of empty fields..

Ties Blom

 
Upvote 0 Downvote
Or a calculation like TOTAL(CASE WHEN (TIME_FIELD = "" OR TIME_FIELD is NULL) THEN (1) ELSE (0) END)).

soi la, soi carré
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

oldCognosUser
  • Locked
  • Question
counting business days without Sa/Su
Replies
0
Views
69
oldCognosUser
oldCognosUser
lymi6977
  • Locked
  • Question
creating fixed length fields in Cognos
Replies
6
Views
263
blom0344
blom0344
khdavis
  • Locked
  • Question
Crosstab Report - Need to Group Columns by 2 Different Date Fields
Replies
1
Views
69
blom0344
blom0344
saragosti
  • Locked
  • Question
Naming fields
Replies
3
Views
60
blom0344
blom0344
jeffreygreen
  • Locked
  • Question
flagging inconsistent text fields based on previous row
Replies
8
Views
148
jeffreygreen
jeffreygreen

Part and Inventory Search

Sponsor

Back
Top