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:
- -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.