Values automatically aggregate between different time scales. However, you can also use functions such as MONTHVALUE or YEARVALUE to aggregate values.

When two line items have a different time scale, and a formula uses both, values aggregate into the greater time scale. For example, days aggregate into months and months into quarters. This aggregation can also skip levels, so days can aggregate into years.

Values do not aggregate from greater time scales into smaller ones. For example, if x has a time scale of months, and y has a time scale of years, y = x aggregates the monthly values into an annual total. However, x = y returns nothing, as y does not contain a value for each month.

You can also use functions such as HALFYEARVALUE, MONTHVALUE, QUARTERVALUE, WEEKVALUE, YEARVALUE, or SELECT to aggregate values into different time scales.

## Examples

The table below contains data with a Time Scale of Year. The module is named Annual Data, and the line item is named Annual revenue.

 FY19 FY20 FY21 FY22 Annual Revenue 538,497 512,693 492,648 586,765

The table below contains data with a Time Scale of Month. It also contains a number of line items that show how you can use different functions to aggregate values into different time scales. However, as each cell is calculated separately, it's often more efficient to use a line item with the time scale required.

 Jan 22 Feb 22 Mar 22 Apr 22 May 22 Jun 22 Jul 22 Aug 22 Sep 22 Oct 22 Nov 22 Dec 22 Monthly Revenue 50,896 52,167 51,359 44,691 43,080 51,271 53,457 50,848 42,151 51,382 48,078 47,385 Years into monthly time scale 'Annual Data'.Annual Revenue 0 0 0 0 0 0 0 0 0 0 0 0 Quarter Revenue QUARTERVALUE(Monthly Revenue) 154,422 154,422 154,422 139,042 139,042 139,042 146,456 146,456 146,456 146,845 146,845 146,845 Half-year Revenue HALFYEARVALUE(Monthly Revenue) 293,464 293,464 293,464 293,464 293,464 293,464 293,301 293,301 293,301 293,301 293,301 293,301 Annual Revenue YEARVALUE(Monthly Revenue) 586,765 586,765 586,765 586,765 586,765 586,765 586,765 586,765 586,765 586,765 586,765 586,765 Average Revenue per Month Annual Revenue / 12 48,897 48,897 48,897 48,897 48,897 48,897 48,897 48,897 48,897 48,897 48,897 48,897

The Years into monthly time scale line item returns a value of 0. This is because values with a Time Scale of Year cannot be aggregated into a Time Scale of Month.

Disclaimer

We update Anapedia regularly to provide the most up-to-date instructions.