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.
QUARTERTODATE(Line item to aggregate)
|Line item to|
|Number||The line item to aggregate in a quarterly timeframe.|
The QUARTERTODATE function returns a number.
In the example below QUARTERTODATE cumulates sales for each quarter.
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.