I want to use the most recent month with Actuals in the quarter for Actuals. THIS IS MY CHALLENGE.

Quarterly Reporting

Quarter

Forecast

Actual

Over/Under

Q1

67

65

-2

Q2

68

67

-1

Q3

70

67

-3

Q4

72

67

-5

So the 65 actual headcount in March was used for Q1, the 67 actuals reported in Jun was used for Q2, and until another actual value is reported, the 67 is carried forward and used to determine the available/over/under values.

In July, if actuals are reported as 68, then Q3 would change to

Q3

70

68

-2

and if August actuals were reported as 70, then Q3 would change to

Q3

70

70

0

I know the answer but have been unable to get PREP to identify and change the actuals w/in the quarter.