Skip to Content
Dec 24, 2019 at 05:51 PM

Headcount by Year and Month in SAC


Hi All,

We want to calculate Headcount by Year and Month based on the below calculation

"Calculate the total number of employees whose hire dates is less than Input date(Provided by user as filter) THEN SUBTRACT the total numbers of leavers whose last working day was less than or equal to Input date"

Ex: Count(Employees) where joining date<=Input Date - Count(Employees) where Resignation date<=Input Date.

Can someone please help how to apply the above condition in SAC either using Calculated Measure or using Script.