AnsweredAssumed Answered

Conditional Summary?

Question asked by JohnGross on Jul 21, 2010
Latest reply on Jul 22, 2010 by philmodjunk


Conditional Summary?



I am trying to create a field that shows the average for all the non-blank fields for all records that meet a criteria on a table. 

So, for example I have a Table with the following fields:

  • -Date
  • -True or False
  • -Numeric Value being averaged (It could possibly be blank)

Now, I wanna be able to take an average of the value for all records matching either True or False and also between a set of dates. I also want to ignore the records where the field I'm averaging is blank. If anyone could point me in the right direction I would be eternally grateful.