TOTALQTD

The TOTALQTD function evaluates the quarter-to-date value of the measure in the current context. It should be used in conjunction with an aggregate function like SUM or AVERAGE.

Syntax#

TOTALQTD([measure])
// Returns the quarter-to-date value of the measure for every quarter

Arguments#

measure – The measure for which data has to be fetched and aggregated. Required.

Return Value#

Range of data. When used with an aggregation function, it returns a scalar value running-calculated to date, according to the period selected.

Example#

Find below an example in which the quantity is cumulatively summed every quarter-to-date.