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