I have a master-master-detail report with sections with in section. The main section is the “region” and sub-sections are “Field Offices”.
I performed sum and average on sub sections and I am getting perfect results. When I create a cell in the body of sub-sections to display the Average and one for Sum and copy the results from the sub-section footer i get different results. The formula for both the footer and the free standing cell is the same ie
Average( In Body) In (, )
When I analyzed the data, I fould out that while calculating SUM for the free standing cell, it is avoiding duplicates and for the AVERAGE it is performing the following calculation.
(SUM without including the duplicates)/(Count - duplicate occuraces +1)
You can’t do that with averages. You need the detail to calculate the average. The way you do it is to copy the whole block to the subsection and then use outlining to hide the detail.
AOA Kashif
I happy that my solution works .This forum help us a lot. I learned all from this forum.I am in Nexgen Solution previously i was worked in Edev.