Hello,
I have a report in a Tabular format and I am wondering if anyone knows how I can create a row that generates a percentage number in RS 2005. Sample data is highlited here in yellow?
Thanks,
School | Dept | Level | Category | Total Courses | Enrollment | Grades Awarded | Grades Attempted | Average GPA | A | A- | B+ | B | B- |
BUE | MGMT | 300 | Classroom Instruction | 30 | 844 | 813 | 817 | 3.213 | 140 | 166 | 164 | 138 | 109 |
17% | 20% | 20% | 17% | 13% |
400 | Classroom Instruction | 32 | 751 | 734 | 740 | 3.417 | 227 | 173 | 135 | 83 | 59 |
31% | 24% | 18% | 11% | 8% |
Does the number under each grade come from a different database field? Assuming for the "A" column, the number is from FieldA, you can calculate the percentage (for number of "A"s for this level from total number of "A"s) using =Fields!FieldA.Value/Sum(Fields!FieldA.Value). For the percentage of the number of "A"s from total number for all grades for a specific level, use =Fields!FieldA.Value/(Fields!FieldA.Value+Fields!FieldA-.Value+Fields!FieldB+.Value+Fields!FieldB.Value+Fields!FieldB-.Value).
No comments:
Post a Comment