For example, you can use the YEARVALUE function to identify sales across a year that are above average.
|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.
You cannot use the YEARVALUE function in a model that has the Calendar Type set to Weeks: General.
Related Anaplan functions
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|
Quarter above average for year