Summary field based on conditions
I've created a summary field that does an average of a numeric field. However, I'd like to get an average of only negative values and another of positive values, resulting in two summary fields. How do I get a summary field to calculate averages only for negative values then another field for positive values?
Also, is there a way to put these summary fields into the footer and have them display in Browse mode, table view?