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.

## Syntax

WEEKVALUE(Line item)

## Arguments

 Argument Data type Description Line item Number, Boolean, date, time period, list, text The 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.

## Constraints

• 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.

## Calculation engine functionality differences

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.

## Examples

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 21 5 Jan 21 6 Jan 21 7 Jan 21 8 Jan 21 9 Jan 21 10 Jan 21 Week 2 FY21 Product Sales 200 254 122 543 233 350 431 304.7 Day below average for week Product Sales < WEEKVALUE(Product Sales)

Disclaimer

We update Anapedia regularly to provide the most up-to-date instructions.