1. Calculation functions
2. All Functions
3. Time and Date Functions
4. MONTHVALUE

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

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.

## 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 Net Profit > MONTHVALUE(Net Profit)