I have a column that is a count of all records (count). I have a column that is the sum of a bit field (1 or 0). I have a column that is an average of that bit field (percentage). I have a column for a total dollar amount (sum). I have a column for the average of that dollar amount, which, for some reason, only gives an average where the bit field is 1. What I need is an average of that dollar amount REGARDLESS of the value of the bit field. Filtering really doesn't work because I need to be able to show both types of average. Any ideas?
Thanks!
- Matt
Bookmarks