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

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

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.

## 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 ProfitTime 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 Net Profit > YEARVALUE(Net Profit)