Average and Variables

VAR Average1 = 0;
VAR Average2 = 0;
VAR Average3 = 0;
VAR CutoffAverage = 0;
VAR AvgOccSuites = 0;
SET CREATENONMISSINGBLK ON;
FIX ("Budget","Full",{Year_Target},{Version},"No Unit Type","Undefined Care Level")
FIX (@RELATIVE("YearTotal",0),@Relative("Retirement Quebec Region 2021 (Alt)",0),"9660050000")


"Value"(
Average1 = "9660050000"->"Actual"->"Final"->{CutOff_Period}->{Year_Source}
/  "Monthly Average Occupied Suites"->"Actual"->"Final"->{CutOff_Period}->{Year_Source};

Average2 = "9660050000"->"Actual"->"Final"->@MEMBER(@SHIFTSIBLING({Cutoff_Period},-1))->{Year_Source}
/ "Monthly Average Occupied Suites"->"Actual"->"Final"->@MEMBER(@SHIFTSIBLING({Cutoff_Period},-1))->{Year_Source};

Average3 = "9660050000"->"Actual"->"Final"->@MEMBER(@SHIFTSIBLING({Cutoff_Period},-2))->{Year_Source}
/ "Monthly Average Occupied Suites"->"Actual"->"Final"->@MEMBER(@SHIFTSIBLING({Cutoff_Period},-2))->{Year_Source};


        CutoffAverage = @AVG(SKIPBOTH,@LIST(Average1,Average2,Average3));
        AvgOccSuites = "Monthly Average Occupied Suites"->"All Care Levels"->"All Unit Types"->{Year_Budget_Source};

"Value" = CutoffAverage * AvgOccSuites;
        
)
  
ENDFIX
ENDFIX