addDays()
The addDays() function provides the ability to add or subtract days from a date. Syntax addDays(date, integer) Argument Description date (required) An...
Functions
-
-
addMonths()
The addMonths() function provides the ability to add or subtract months from a date. Syntax addMonths(date, integer) Argument Description date... -
addWorkDays()
The addWorkDays() function provides the ability to add or subtract weekdays (i.e., Monday through Friday) from a date. Syntax addWorkDays(date,... -
addYears()
The addYears() function provides the ability to add or subtract years from a date. Syntax addYears(date, integer) Argument Description date... -
average()
The average() function returns the average value from a set of values and returns a time-series array. Syntax average(value1, value2, [value3]…) Argument... -
averageif()
The averageif() function returns the average value across all instances of a specified template. The instances must be descendants (e.g.,... -
betweenDates()
The betweenDates() function returns the specified values between two dates into a time-series array. Syntax betweenDates(value, startDate, endDate) Argument Description value (required)... -
countif()
The countif() function returns the number of instances of a specified template. The instances must be descendants (e.g., children, grandchildren,... -
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... -
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...