Range Calculations

Range calculations can be used to derive the value of a timephased attribute over a defined period. A range calculation is used in a MathML calculation as the value for the name attribute in the RHSVariable element. A range calculation syntax has six components:
The syntax is the six components of the range calculation presented (in order), each component contained within a percent symbol (%):
%RangeCalculation%Calculation%Attribute.Dimension
     %Units%Timescale%Range1%Range2%
For example, to find the sum of all timephased attributes in the Labor-Currency group that is part of the Plan dimension with a range from a milestone that is part of the Plan dimension through 12/1/2008, the range calculation would be:
%RangeCalculation%SUM%Labor-Currency.Plan%CURRENCY
     %CALENDAR_MONTH%StartMS.Plan%12/1/2008%
To find the monthly average cost for all timephased attributes in the Server group that is part of the Plan dimension from today through the end of the fiscal year, the range calculation would be:
%RangeCalculation%AVG%Server.Plan%CURRENCY
     %CALENDAR_MONTH%TODAY%FISCAL_YEAR_END%
To find the sum of all increased revenue in the Plan dimension for an entire calendar year and the Plan dimension is defined to begin on 1/1/2007 and end on 1/1/2008, the range calculation would be:
%RangeCalculation%SUM%IncreasedRevenue.Plan%CURRENCY
     %CALENDAR_YEAR%Start.Plan%Finish.Plan%
To use a range index to find the sum of all increased revenue in the Plan dimension for three calendar years (back from the current calendar year) and the Plan dimension is defined to begin on 1/1/2007 and end on 1/1/2008, the range calculation would be:
%RangeCalculation%SUM%IncreasedRevenue.Plan%CURRENCY
     %YEAR_START%Start.Plan,-2%Finish.Plan%
To use a range index to find the sum of all increased revenue in the Plan dimension for the two previous calendar years (back from the current calendar year) and the Plan dimension is defined to begin on 1/1/2007 and end on 1/1/2008, the range calculation would be:
%RangeCalculation%SUM%IncreasedRevenue.Plan%CURRENCY
     %YEAR_START%Start.Plan,-2%Finish.Plan,-1%