Aged Reqs

Content

Plan is to count the no of aged reqs over 40days and then remove any req that has the following submision statuses Hire/Accepted,Awaiting....

I did this but it is still including those submissions. How can I do this?

FILTER(count(cast(case when (CASE WHEN DAYOFWEEK("Requisition First Sourcing Date"."Req. First Sourcing Date") > DAYOFWEEK(NOW()) THEN CASE WHEN DAYOFWEEK("Requisition First Sourcing Date"."Req. First Sourcing Date") = 7 THEN TIMESTAMPDIFF(SQL_TSI_DAY, "Requisition First Sourcing Date"."Req. First Sourcing Date", NOW()) - (Floor(TIMESTAMPDIFF(SQL_TSI_DAY, "Requisition First Sourcing Date"."Req. First Sourcing Date", NOW())/7)*2)-1 ELSE TIMESTAMPDIFF(SQL_TSI_DAY, "Requisition First Sourcing Date"."Req. First Sourcing Date", NOW()) - (Floor(TIMESTAMPDIFF(SQL_TSI_DAY, "Requisition First Sourcing Date"."Req. First Sourcing Date", NOW())/7)*2)-2 END ELSE TIMESTAMPDIFF(SQL_TSI_DAY, "Requisition First Sourcing Date"."Req. First Sourcing Date", NOW()) - (Floor(TIMESTAMPDIFF(SQL_TSI_DAY, "Requisition First Sourcing Date"."Req. First Sourcing Date", NOW())/7)*2) END-("Requisition Process Time"."Req. Total Days On Hold")*0.7143) > 39 then '1' end as integer)