AnsweredAssumed Answered

Counting related records only when certain conditions exist

Question asked by jconner99 on Aug 14, 2012
Latest reply on Aug 14, 2012 by philmodjunk

Title

Counting related records only when certain conditions exist

Post

 I am trying to do a calculation that counts the number of related records when two conditions exist. In the main table, I have a field called NumberOfRecords which I made a calculation that returns a number. In the related record there are two fields that must have certain data in to be added to the count. Both are dates. The data is inputted from another source.

Date1 can be either "--" or a valid date

Date2 can be either "--" or a valid date

Only records were Date1 = "--" and Date2 = Valid Date should be counted.

 

Outcomes