For example, you can use the MONTHVALUE function to identify what percentage a given week contributes to monthly sales.
Syntax
MONTHVALUE(Line item)
Arguments
Argument | Data type | Description |
Line item | Number, Boolean, date, time period, list, text | The line item to reference the monthly time summary value for. |
The MONTHVALUE function returns a result of the same data type as the line item you reference.
Constraints
- If the line item you reference has a time scale of Quarter or above, then the reference returns the line item's default value. For example,
0
for numeric line items. - You cannot use the MONTHVALUE function in a model that has the Calendar Type set to Weeks: General.
Calculation engine functionality differences
In Polaris, you cannot use the MONTHVALUE 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 Net Profit line item has a numeric data type, and the Week above average for month line item has a Boolean data type.
In Blueprint, in the Summary column for Net Profit, Time Summary is set to Average. The formula returns a TRUE result for values that are above average for each week in the month.
Week 1 FY21 | Week 2 FY21 | Week 3 FY21 | Week 4 FY21 | Jan 21 | |
Net Profit | 833 | 860 | 867 | 812 | 843 |
Week above average for month
|