bookman

Count 2 Fields Combined

Discussion created by bookman on Jul 12, 2012
Latest reply on Jul 16, 2012 by bookman

What does a calculation look like that counts the number of records with a Date Created 2012 but omits or is constrained by a field called Selected as a Previewer?

 

Should the field type be a Calculation or a Summary?

The result should be a Number.

 

I keep getting error messages re: field doesn't exist, wrong function, or needs an operator.

 

I am a novice, this is the first time I've tried to create a calculation, but I'm good at following directions.

I'm guessing my errors are related to the "parentheses" or the position of "not" or the "2012" in the Date Created, or whatever.

 

The attachment shows my last attempt.

 

Please help.

 

Mel

 

PS. My last posting was marked as a question with a 15-minute time limit. I hope this didn't cause a problem. This posting supersedes it.

Attachments

Outcomes