Open Req formula help needed

Summary

Req formula

Content

Hi all

I had to rewrite most of my formula's for some reason after a recent upgrade and having a hard time showing the req as "Open" it still is showing as "Open" even though it is on hold

Any help is appreciated)

COUNT(case when "Candidate Counts"."# Submissions Offer Accepted" = 0 AND "Requisition Status - Current"."Current Status" = 'Sourcing'  then "Requisition Identification"."# Openings" 

when "Candidate Counts"."# Submissions Offer Accepted"= 0 AND "Requisition Status - Current"."Current Status" = 'Approved'  then "Requisition Identification"."# Openings"  

when "Candidate Counts"."# Submissions" = 0 AND "Requisition Status - Current"."Current Status" = 'Sourcing'  then "Requisition Identification"."# Openings"