Hello Friends,
I need help in projecting payroll for the next fiscal year starting in FY24 Oct ending FY24 Sep, which equates to 26 pay periods in a fiscal year.
The payroll data had just populated for pay period 09/09/2023 within specific funding buckets. I have also built in a "what if analysis to hire at 98% which gives me 100 FTEs to hire against the authorized strength of 1170.
I wanted to measure on the graph against the actual payroll when we start the new fiscal year.
Every time I use the "FY23AVGSalarySEPASGN" formula:
FY23AVGSalarySEP(ASGN) =
CALCULATE(
DIVIDE(
SUMX(
FILTER(FY23Payroll,FY23Payroll[Pay Period End Date] =DATE(2023,09,09)),
FY23Payroll[AMOUNT PAID (DETAIL)]
),1)
*26/[FY23ASGN]
to multiply against the projected assigned strength of 100
Proj to Hire = CALCULATE(
[FY24 PROJ ASGN]-SUMX(
FILTER(FY23ORG,FY23ORG[Date] >= DATE(2023,08,01) &&
FY23ORG[Date] <= DATE(2023,08,01)
),
FY23ORG[ASGN]))
I'm not able to graph total. Is there a better way to write the formula?
