By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,148 Members | 779 Online
Bytes IT Community
+ Ask a Question
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
Share this Question
Share on Google+
3 Replies


P: 4
Can anyone help? Please?
May 1 '07 #2

NeoPa
Expert Mod 15k+
P: 31,494
Please do not *BUMP* your thread before at least 24 hours have passed.
Our experts and members offer their time voluntarily and do not deserve to be treated with impatience by those who may benefit from their efforts.

MODERATOR.

PS. As many look out for threads with no replies, you may well, ironically, have caused those same experts to bypass your thread.
May 4 '07 #3

NeoPa
Expert Mod 15k+
P: 31,494
Getting back to your question :
Can you post the table MetaData of your data. I didn't find your explanation very clear as to how the data works together.
Here is an example of how to post table MetaData :
Table Name=tblStudent
Expand|Select|Wrap|Line Numbers
  1. Field; Type; IndexInfo
  2. StudentID; Autonumber; PK
  3. Family; String; FK
  4. Name; String
  5. University; String; FK
  6. Mark; Numeric
  7. LastAttendance; Date/Time
Also, what are the (relevant) controls (particularly their formulas) that are in your report? Perhaps your problem is simply accessing the wrong item in your formula, but we can't tell without seeing it.
May 4 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.