# Active Openings on Hold

Summary

Report on # Openings (not # Requisitions) on Hold

Content

I have a request to report on the # of openings, # of openings on hold, and # of active openings.  I am struggling with the formula as it is only returning # openings left to fill, even when I use a filter, here is the formula I am using now for # Openings on Hold.  I figure once I get that formula right, then I can use # Openings minus that new formula to equal # Active Openings.

FILTER("Requisition Counts"."# Openings Left To Fill (Hired)" USING ("Requisition Status - Current"."Current Status" = 'On Hold'))

# Openings: How many openings on the requisition