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 
Number The line item to cumulate over half-year periods.

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.

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
YEARTODATE
(Sales)

24,977

53,477

34,585

66,293

 37,102

71,045

41,663

80,001