Monday, March 19, 2012

How to create a row that calucates percentage in a Tabular report, RS 2005?

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