1. Calculation functions
  2. All functions
  3. Time and date functions
  4. HALFYEARTODATE

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

ArgumentData TypeDescription
Line item to
cumulate 
NumberThe 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.
  • This function cannot be used 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.

Example

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

Disclaimer

We may update our documentation occasionally, but will only do so in a way that does not negatively affect the features and functionality of the Anaplan service.