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