For example, you can use the QUARTERVALUE function to identify monthly sales that fell below average in a quarter.
Syntax
QUARTERVALUE(Line item)
Arguments
Argument | Data type | Description |
Line item | Number, Boolean, date, time period, list, text | The 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
0
for numeric line items.
in the model settings bar, the QUARTERVALUE function returns the line item's default value. For example, - 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 21 | Feb 21 | Mar 21 | Q1 FY21 | |
Cost of Goods | 198,000 | 190,453 | 123,000 | 170,484 |
Month below average for quarter
|