cumulative()

The cumulative() function returns the accumulated values of a metric since a designated date into a time-series array.

Syntax

cumulative(value, date)

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.

date

(optional)

The date the accumulation should begin.  The date format should be in the form YYYY-MM-DD and enclosed in quotation marks.

Note: If the date is not included, it defaults to 10 years before the enterprise creation date.

Where Available

  • Metric expression

Examples

Where Example(s)
Metric expression

 

cumulative(CAPEX__m, "2023-01-01")

cumulative(CAPEX__m * currency_conversion__c, "2023-01-01")

cumulative(sumif(Initiative__t, CAPEX__m, active))

 

Updated on February 7, 2023

Related Articles