Hello All,
I want to create this Query with expression:
select
sum( case when Total_Time <= :T Then 1 Else 0 End ) / Count(1) * 100 Perc_Acheived
From
(
SELECT application_no, SUM (work_time) total_time
FROM FN_WFLOG_MV
WHERE
(application_no, applicant_no) IN
(SELECT application_no, applicant_no
FROM FN_WFLOG_MV
WHERE WF_TASK_NAME = 'Task1'
AND TO_CHAR (ACTION_DATE, 'YYYYQ') = :Q
AND USERID IS NOT NULL
AND TO_WF_TASK_NAME = 'To_Task1'
AND ACTION_NAME = 'Action1')
AND TO_CHAR (ACTION_DATE, 'YYYYQ') = :Q
AND DEPT_NAME = 'DEPT1'
AND WF_TASK_NAME = 'TASK1'
GROUP BY application_no
T is a variable for Days
Q is for Year and Quarter
output is a percentage...