The HALFYEARTODATE function cumulates values from a single numeric parameter, over a half-year period. The HALFYEARTODATE cumulation starts at the Fiscal Year Start Month as selected in the Model Calendar, and resets every half-year.

You could use HALFYEARTODATE to track revenue over half-year periods.

## Syntax

HALFYEARTODATE(Line item to cumulate)

## Arguments

 Argument Data Type Description Line item to cumulate Number The line item to cumulate over half-year periods.

The HALFYEARTODATE function returns a number.

## Syntax example

HALFYEARTODATE(Sales)

## Constraints

• The Time Scale of source must be Day, Week, Month, or Quarter.
• You cannot use this function if model Calendar Type is Weeks: General.

## Calculation engine functionality differences

In Polaris, you can use the HALFYEARTODATE function with line items with a time scale of Half-Year. In the Classic Engine, you cannot.

In Polaris, you cannot use HALFYEARTODATE in formulas of line items with a formula summary method. In the Classic Engine, you can.

## Example

The example below shows HALFYEARTODATE applied to sales.

 Q1 FY18 Q2 FY18 Q1 FY19 Q2 FY19 Q1 FY20 Q2 FY20 Q1 FY21 Q2 FY21 Sales 24,977 28,500 34,585 31,708 37,102 33,943 41,663 38,338 HALFYEARTODATE (Sales) 24,977 53,477 34,585 66,293 37,102 71,045 41,663 80,001

Disclaimer

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