1. Calculation functions
  2. All Functions
  3. Time and Date Functions
  4. QUARTERTODATE

QUARTERTODATE accumulates values from a single numeric parameter, within a quarterly time range.

You could use QUARTERTODATE to compare orders received this quarter with the orders from previous quarters, up to and including the same day. QUARTERTODATE resets at each quarterly interval.

Syntax

QUARTERTODATE(Line item to aggregate)

Arguments

ArgumentData TypeDescription
Line item to
aggregate 
Number The line item to aggregate in a quarterly timeframe.

The QUARTERTODATE function returns a number.

Syntax example

QUARTERTODATE(Sales)

In the example below QUARTERTODATE  cumulates sales for each quarter. 


Jan
2021
Feb
2021
Mar
2021
Apr
2021
May
2021
Jun
2021
Sales88,425 92,680 91,36886,328 97,76394328
QUARTERTODATE
(Sales)
88,425181,105272,47386,328184,091278,419

Constraints

The line item that contains the QUARTERTODATE function must have a Time Scale of Day, Week, or Month.

Calculation engine functionality differences

In Polaris, you can use the QUARTERTODATE function with line items that have a matching time scale. For example, you can use QUARTERTODATE with a line item with a time scale of Quarter.

In the Classic Engine, you cannot.

Related Anaplan functions