Project Payroll Using a Specific Pay Period and Graph the Projections
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?