1. Calculation functions
  2. All Functions
  3. Time and Date Functions
  4. QUARTERVALUE

The QUARTERVALUE function references another line item and returns the quarterly time summary in place of the detail value.

For example, you can use the QUARTERVALUE function to identify monthly sales that fell below average in a quarter.

Syntax

QUARTERVALUE(Line item)

Arguments

ArgumentData typeDescription
Line itemNumber, Boolean, date, time period, list, textThe line item to reference the quarterly time summary value for.

The QUARTERVALUE function returns a result of the same data type as the line item you reference.

Constraints

  • If you do not select Quarter Totals in Time in the model settings bar, the QUARTERVALUE function returns the line item's default value. For example, 0 for numeric line items.
  • You cannot use the QUARTERVALUE function in a model that has the Calendar Type set to Weeks: General.

Calculation engine functionality differences

In Polaris, you cannot use the QUARTERVALUE function in a result line item with a Time Scale greater than the function.

The Classic engine returns a value of 0 in this case.

Related Anaplan functions

Examples

In this example, an Income Statement module has line items on rows and Time on columns. The Cost of Goods line item has a numeric data type, and the Month below average for quarter line item has a Boolean data type.

In Blueprint, in the Summary column for Cost of Goods, Time Summary is set to Average. The formula returns a TRUE result for values that are below average for each month in the quarter.


Jan 21Feb 21Mar 21Q1 FY21
Cost of Goods198,000190,453123,000170,484

Month below average for quarter

Cost of Goods > QUARTERVALUE(Cost of Goods)