For example, you can use the YEARVALUE function to identify sales across a year that are above average.
Syntax
YEARVALUE(Line item)
Arguments
Argument | Data type | Description |
Line item | Number, Boolean, date, time period, list, text | The line item to reference the yearly time summary value for. |
The YEARVALUE function returns a result of the same data type as the line item you reference.
Constraints
You cannot use the YEARVALUE function in a model that has the Calendar Type set to Weeks: General.
Calculation engine functionality differences
In Polaris, you cannot use the YEARVALUE 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 Net Profit line item has a numeric data type, and the Quarter above average for year line item has a Boolean data type.
In Blueprint, in the Summary column for Net Profit, Time Summary is set to Average. The formula returns a TRUE result for values that are above average for each quarter in the year.
Q1 FY21 | Q2 FY21 | Q3 FY21 | Q4 FY21 | FY21 | |
Net Profit | 660,338 | 567,656 | 457,374 | 446,662 | 533,007 |
Quarter above average for year
|