Difficulty with collecting a value in one table when there is no value in another table

[#1]

I need to calculate FTEs. Sometimes a department has no hours for a month but there are hours for the other months.

A year-to-date FTE sums total hours for the entire year and divides by the FTE calculator for the entire year.

How do I collect the FTE calculator for all months even when there are no hours for one or more months?

Dept 1000 FE should be 2,732 / 862.85=3.2. There are no hours for Feb.

Dept 1100 is correct 1,928 / 862.85=2.2.

I'm using set analysis to collect the hours and FTE calculator.

Sum({<PeriodYear={$(vMaxYear)}>Actual)

/

Sum({$<PeriodYear={$(vMaxYear)},FTEMonth>}FTECalc)

Thanks

Doug