In the following report in built using Cognos 8
Current Previous Current Previous
Month Month Enrollments Enrollments
1 12 10,266 10,266
2 1 11,290 11,290
3 2 16,981 16,981
4 3 12,413 12,413
5 4 13,284 13,284
6 5 14,652 14,652
7 6 14,937 14,937
8 7 12,369 12,369
9 8 13,312 13,312
10 9 12,698 12,698
11 10 9,685 9,685
12 11 4,862 4,862
- we are trying to have the previous month's enrollments display in order to show a percentage change - the calculation for the column Previous Enrollments is esentially to count(distinct(IDNumbers)for(PreviousMonth)- with Current Month and Previous Month both being based on a- month(EnrollmentDate)-conversion and then grouped.
So far we are coming up with the same figure in each column. Any suggestions on how to remedy this?
any help would be greatly appreciated!
barry
Current Previous Current Previous
Month Month Enrollments Enrollments
1 12 10,266 10,266
2 1 11,290 11,290
3 2 16,981 16,981
4 3 12,413 12,413
5 4 13,284 13,284
6 5 14,652 14,652
7 6 14,937 14,937
8 7 12,369 12,369
9 8 13,312 13,312
10 9 12,698 12,698
11 10 9,685 9,685
12 11 4,862 4,862
- we are trying to have the previous month's enrollments display in order to show a percentage change - the calculation for the column Previous Enrollments is esentially to count(distinct(IDNumbers)for(PreviousMonth)- with Current Month and Previous Month both being based on a- month(EnrollmentDate)-conversion and then grouped.
So far we are coming up with the same figure in each column. Any suggestions on how to remedy this?
any help would be greatly appreciated!
barry