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.
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)
Argument | Data Type | Description |
Line item to cumulate | Number | The line item to cumulate over half-year periods. |
The HALFYEARTODATE function returns a number.
HALFYEARTODATE(Sales)
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.
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 content regularly to provide the most up-to-date instructions.