The general problem I am having is when I calculate my percent, it displays the same percent for each row.
My report is based on the following query......
Table 1 (testing information for each person) LEFT JOIN Table 2 (person information)
In the query, I count the number of people that fit my "where" criteria which is applied using one field from each table. That is, I apply the "where" criteria to one field in Table 1 and one field in Table 2. I "group by" another two different fields from the testing information table (FIELD 1 and FIELD 2, respectively) and what group they were assigned to.
In my report, I have 3 columns. The first one lists unique values for FIELD 2 from Table 2, the second one lists unique values for FIELD 1 from Table 2, and the 3rd one shows the counts for each value shown in the report.
To calculate a percent, I create an unbound text box. In it, I write "=count/sum(count)". When I preview the report, it shows the same percent on each row, even though the counts are not the same. I can't figure out why it is doing this.
My other goal is to create percentages using two different denominators. I want to sum up the counts for FIELD 1 and use that as the denominator for FIELD 1 percentages. Then do the same for FIELD 2. Is this possible or will I just have to create separate reports?
My report is based on the following query......
Table 1 (testing information for each person) LEFT JOIN Table 2 (person information)
In the query, I count the number of people that fit my "where" criteria which is applied using one field from each table. That is, I apply the "where" criteria to one field in Table 1 and one field in Table 2. I "group by" another two different fields from the testing information table (FIELD 1 and FIELD 2, respectively) and what group they were assigned to.
In my report, I have 3 columns. The first one lists unique values for FIELD 2 from Table 2, the second one lists unique values for FIELD 1 from Table 2, and the 3rd one shows the counts for each value shown in the report.
To calculate a percent, I create an unbound text box. In it, I write "=count/sum(count)". When I preview the report, it shows the same percent on each row, even though the counts are not the same. I can't figure out why it is doing this.
My other goal is to create percentages using two different denominators. I want to sum up the counts for FIELD 1 and use that as the denominator for FIELD 1 percentages. Then do the same for FIELD 2. Is this possible or will I just have to create separate reports?
