I want to define subtotals (specifically averages) in a grouped report, but I want to exclude values over 199 from the calculation. It appears that DAvg should achieve this but it actually produces some very odd results (but does not give an error message). Should I be able to use DAvg to do this? If so, how?
As an alternative, I tried inserting a calculated field that returns the original value if less than 200, and NULL if the original value is 200+. This works in itself, but I then can't insert it into the AVG function and run the report (it comes up with a demand for parameters to be inserted). Should I be able to use this alternative approach? Is there a third option?
As an alternative, I tried inserting a calculated field that returns the original value if less than 200, and NULL if the original value is 200+. This works in itself, but I then can't insert it into the AVG function and run the report (it comes up with a demand for parameters to be inserted). Should I be able to use this alternative approach? Is there a third option?