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.
Related Anaplan functions
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
|