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

For example, you can use the WEEKVALUE function to identify daily sales that fell below average in a certain week.

WEEKVALUE(Line item)

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

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

In Polaris, you cannot use the WEEKVALUE 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.

  • The line item that contains the WEEKVALUE function must have a time scale of Day or Week.
  • You can only use the WEEKVALUE function in models where the calendar type is based on weeks.

In this example, a Product Sales module has line items on rows and Time on columns. The Product Sales line item has a numeric data type, and the Day below average for week line item has a Boolean data type.

In Blueprint, in the Summary column for Product Sales, Time Summary is set to Average. The formula returns a TRUE result for values that are below average for each day in the week.

4 Jan 215 Jan 216 Jan 217 Jan 218 Jan 219 Jan 2110 Jan 21Week 2 FY21
Product Sales200254122543233350431304.7

Day below average for week

Product Sales < WEEKVALUE(Product Sales)