+3Currently percentages are sums instead of averages on the "Total and Averages Row" for my table reports. Having an average of my percentages but a total of my other numeric data is what I am looking for in this line. Is there a way for %s to be averaged on that final row instead of totaled? Screenshot for reference.
Thanks in advance!
Best answer by MarkShnierYou
It is a field property. But simply clicking the field to show averages instead of totals may not result in an average which is mathematically correct.
You will get an average of the averages but that does not mean it's a proper weighted average of the total. It could literally an average of each line item but one line items could be for 1 million widgets and the other item the other line item could be for 1 widget and they will be treated equally.
There are more advanced features of summary reports which may allow a proper calculation
+22It is a field property. But simply clicking the field to show averages instead of totals may not result in an average which is mathematically correct.
You will get an average of the averages but that does not mean it's a proper weighted average of the total. It could literally an average of each line item but one line items could be for 1 million widgets and the other item the other line item could be for 1 widget and they will be treated equally.
There are more advanced features of summary reports which may allow a proper calculation
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
