AnsweredAssumed Answered

Total Count of 1 Field Constrained by another Field

Question asked by bookman on Jul 12, 2012
Latest reply on Jul 13, 2012 by philmodjunk

Title

Total Count of 1 Field Constrained by another Field

Post

What does a calculation look like that counts the number of records with aDate 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

Post1.png

Outcomes