cumulativeYTD() 

The cumulativeYTD() function returns the accumulated values of a metric for the current fiscal year into a time-series array.

Syntax

cumulativeYTD(value)

Argument Description
value

(required)

The expression returning the values to be accumulated. 

The expression can simply be the metric API name of the metric to be aggregated or could be a more complex expression that returns a time-series array of values to be aggregated.

Where Available

  • Metric expression

Examples

Where Example(s)
Metric expression

 

cumulativeYTD(CAPEX__m)

cumulativeYTD(sumif(Initiative__t, CAPEX__m, active))

 

Updated on February 7, 2023

Related Articles