I have a question. The below formula will return the correct result for the most recent month in the trend but it will not return the correct result for all of the previous months in the trend. I think it is because it is not evaluation the condition within each month of the trend correctly. Is there a way I can fix my set analysis to so it does?
=
(
Count({$<[Employee] = {"=
(
Round(
Sum(
Aggr(
(sum({<[Cost Center]=>}
[Hours] )/$(vFactor)
)
,[Employee],[Pay Period]
)
, 0.01 )
) >$(vHighFTEThreshold)
"},
CalendarDate= {'>=$(vRoll13PPBegDate)<=$(vMaxDate)'}
, [PR Year]=
, [Pay Pd]=
, [Pay Period]=
>
}Distinct [Employee]
)
)
