Count Number of presents,Number of Absents and overall present percentage.

0

hi,

     I want to calculate number of presents,absents and over all present persentage.

    I had started creating a report using cross tab,need to perform the calculations for number of presents,absents and present persentage.

My sample query is like,

select std.rollno,std.studentname,cdate.classdate,atd.curr_attnd_roster_attendance,
 CASE
           WHEN atd.curr_attnd_roster_attendance = 'Present' THEN 'P'
           WHEN atd.curr_attnd_roster_attendance = 'Absent' THEN 'A'
           ELSE 'unknown'
  END AS Attendance

from studentdetails as std,classdate as cdate,curr_attnd_roster atd

Created a report using crosstab and got strucked in counting the number of presents,absents.

Variables I have used to create a below report,

$V{rollno},$V{studentname},$V{classdate},$V{attedance}

Sample data displays as,

Rollno      StudentName   05/03   06/03   07/03    08/03   09/03   Presents    Absents      Persentage

1122           Raghu                   P           P             A             P           A            ?                 ?                    ?

1123           Suresh                  A           A            P              P            P           ?                  ?                    ?

1124           Rajesh                 P            P             A            A           A            ?                  ?                     ?

What I need is,

Rollno      StudentName   05/03   06/03   07/03    08/03   09/03   Presents    Absents      Persentage

1122           Raghu                   P           P             A             P           A            3                 2                    60%

1123           Suresh                  A           A            P              P            P           3                  2                    60%

1124           Rajesh                 P            P             A            A           A            2                  3                     40%

Guys please help me as I am finding difficult to perform calculation where I need to count  the number of presents,absents and present persentage.

To perform the calculation I need to know what are the variable should I create , what are the variable expressions should I write and how to use those variables to make my need satisfy.

Please help me in sharing the procedure for performing the count values and persentage calculation.

Thank's in advance.

sumithnangunuri's picture
Joined: Nov 9 2017 - 2:41am
Last seen: 11 months 3 weeks ago

0 Answers:

No answers yet
Feedback