|
Re: Rank/Position Calculation. [message #632246 is a reply to message #632230] |
Wed, 28 January 2015 03:13 |
cookiemonster
Messages: 13917 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Running the query against the test case data you provided gives the correct results as far as I can see.
SNO OBTMARKS EXAMC TOTMARKS SEE SUBJECT STUID DIS POS PERC
---- -------- --------------- -------- ---------- ---------- -------- ---------- ---------- ----------
1 40.00 1st Term Exams 50 KG/A English 22 ALI 1 80.7142857
1 33.00 1st Term Exams 50 KG/A English 23 ABB 2 70.7142857
2 25.50 1st Term Exams 50 KG/A Math 24 AII 3 55
2 25.00 1st Term Exams 50 KG/A Math 24 AII 3 55
2 33.00 1st Term Exams 50 KG/A Math 23 ABB 2 70.7142857
2 33.00 1st Term Exams 50 KG/A Math 22 ALI 1 80.7142857
3 40.00 1st Term Exams 40 KG/A Urdu 22 ALI 1 80.7142857
3 33.00 1st Term Exams 40 KG/A Urdu 23 ABB 2 70.7142857
3 25.50 1st Term Exams 40 KG/A Urdu 24 AII 3 55
You need to supply some data that'll cause the query to give the wrong results.
Post it directly in the thread in code tags, rather than as a file - some people can't/won't download them.
|
|
|
|
Re: Rank/Position Calculation. [message #632248 is a reply to message #632247] |
Wed, 28 January 2015 04:24 |
cookiemonster
Messages: 13917 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Well the last query you supplied can't possibly give the above output.
So you need to supply the query(s) (and formula columns if applicable) that the report is actually using.
|
|
|