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.
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.
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|
Years into monthly time scale
Average Revenue per Month
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.