I am having problems with the Row_Number function. I am using it to assign row numbers to records where a student has a grade of pass on a module and excluding failed modules (I want it to show a 0 as row number for failed modules). The problem is that when I try to use a condition, the report still assigns a row number to a failed module though it doesnt display it (it displays a 0 which I wanted it to show). The results appear as follows:
| Row number | Module | Grade |
|---|
| 1 | ModuleA | Pass |
| 2 | ModuleB | Pass |
| 0 | ModuleC | Fail |
| 4 (instead of 3) | ModuleD | Pass |
| | |
How can I make it skip assigning a row number to all failed modules? Please assist.
Thanks.