Date Range with cut off score

[BiliBoy]

Hello Members

I just joined this forum. Right now i have one requirement that requires extracting the correct score between two diffrent dates and  chek against the cut off score, if extracted score is less that cut off score than red(etc.) else green(etc..). so how do i  calculate score between dates.  lets say my score is B from the  exam and cut off score for the exam is C between  two different dates than i am red. but after some time if i take the exam  again and i score D and cut off score for that time period (different time period than first one) is still C than i am green. i am requesting all the experts and guru's here to help me building this logic in report studio. i am new to cognos and developing list  report.

[blom0344]

Interesting challenge.  First question would be on how the cut-off score is fetched. Is this a value entered as a prompt parameter? Is it related to the period and can it be fetched within a query. Should the report work with multiple cutt-off values, i.e. should the report cover multiple exams in time?

[Lynn]

In addition to Blom's question, you mention extracting the score between two dates and also calculating the score between two dates. Which is it? Is it possible to find more than one score within a date range and if so, how does that affect the comparison to the cut off.

Perhaps a rough mockup of what your data looks like would help.

[BiliBoy]

Hello

Lets say student John is in grade 1 with most recent score of A from KG. now he is in grade 1.now cut off score would be from july to october is 'E' than july to end of december 'G' and last december to end of year 'I'.  now during these three different time period he takes exam in grade 1. If he does not  surpass the july-oct grade which is' E' than he is red otherwise green. same thing for other two time period. There is one constant(parameter), current year.2012-2013. so basically i am checking yearly progress of john against diffrent cut off scores, which are hard coded no need to extract. john current score has to be checked against three different time period during 2012-2013.

i hope , i have explained correctly. Thanks for your replies members.

[pricter]

Without knowing the "master data" I suppose that you need to create a data item with the following expression.
if
(
((Month between July and October) AND (Grade > E))
OR
((Month between October and December) AND (Grade > G))
OR
((Month = December) AND (Grade > I))
)
then
green
else
red
The above solution it would work if the ranges and the cut-off codes are hard coded and you "master data" look like the following
Month   Degree
July           A
November C etc

[BiliBoy]

Thanks.. Pricter