asked on
Crystal Reports - Summary formula is not available to use for averaging.
This is related to a question a question and solution that was posted last week:
https://www.experts-exchange.com/questions/29186944/Cost-difference-over-a-12-month-period-if-there-are-12-months-to-compare.html
Following the solution, the Cost Difference calculates properly. See report -
Version Comparison - 12 MONTH PCA - Copy 2.pdf
On the last page, I'd like to be able to show the average of the cost difference by Project ID, which is Group Header #1 and Group Footer #1. The formula field "Display Difference" is not available to select for a running total formula. Also, if I try to select that formula field and use Insert Summary, the field is not available to summarize.
I'd like to show the average of the Display Difference numbers in the project id / Group Footer #1 area. See below.
https://www.experts-exchange.com/questions/29186944/Cost-difference-over-a-12-month-period-if-there-are-12-months-to-compare.html
Following the solution, the Cost Difference calculates properly. See report -
Version Comparison - 12 MONTH PCA - Copy 2.pdf
On the last page, I'd like to be able to show the average of the cost difference by Project ID, which is Group Header #1 and Group Footer #1. The formula field "Display Difference" is not available to select for a running total formula. Also, if I try to select that formula field and use Insert Summary, the field is not available to summarize.
I'd like to show the average of the Display Difference numbers in the project id / Group Footer #1 area. See below.
Crystal Reports
Last Comment
Mike McCracken