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)

ArgumentData TypeDescription
Line item to
cumulate 
NumberThe line item to cumulate over half-year periods.

The HALFYEARTODATE function returns a number.

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.

HALFYEARTODATE(Sales)

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

The example below shows HALFYEARTODATE applied to sales.


Q1
FY18
Q2
FY18
Q1
FY19
Q2
FY19
Q1 FY20Q2 FY20Q1
FY21
Q2
FY21
Sales24,977 28,50034,58531,708 37,10233,94341,66338,338
HALFYEARTODATE
(Sales)

24,977

53,477

34,585

66,293

 37,102

71,045

41,663

80,001