435,148 Members | 779 Online
Need help? Post your question and get tips & solutions from a community of 435,148 IT Pros & Developers. It's quick & easy.

# Report footer calculation

 P: 4 Greetings, I am creating a frequency report. I have 41 records, each record has sub-records from a source table. I am trying to detemine the frequency that each sub-record appears in a main record. So, if a sub-record appears 5 times, the formula would be 5/41=0.12. The frequency calculation I currently have is residing in the footer of a report listed by sub-record. The footer displays sub-record name, total observations, and the frequency. The problem is that I can't get the denominator constant. I want the denominator to be the max number of records, but as it is in the footer, it is using the highest record that the sub-record appears in. Thus, if sub-record A appears five times, but the highest value is in record number 13, the calculation becomes 5/13=0.38; when the desired is 5/41=0.12. Is there a way to point the denominator to the total records, rather than it looking at the highest sub-record value? Thanks for any help! May 1 '07 #1