Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Calculating FTE - events in progress

I am attempting calculate the total FTE in a given reporting period, such as a month. FTE=(worked days in reportingperiod)/(available days in reportingperiod)*availability We use weekdays to calc...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

You can create a calculated column as below in table [70 EmploymentHistory]:

Workdays for per person =
VAR StartReportingPeriod =
    MIN ( '10 Calendar'[Date] )
VAR EndReportingPeriod =
    MAX ( '10 Calendar'[Date] )
VAR _countofwkdays =
    CALCULATE (
        COUNTROWS ( '10 Calendar' ),
        FILTER ( '10 Calendar', '10 Calendar'[WeekdayWeekend] = "Weekday" ),
        DATESBETWEEN (
            '10 Calendar'[Date],
            '70 EmploymentHistory'[EpisodeStartDate],
            '70 EmploymentHistory'[EpisodeEndDate]
        )
    )
RETURN
    DIVIDE (
        _countofwkdays,
        DATEDIFF ( StartReportingPeriod, EndReportingPeriod, DAY ) + 1
    ) * '70 EmploymentHistory'[Availability]

If the above one is not what you want, please explain more details of your expected result with some examples. Thank you.

Best Regards

Rena