Sum format

Sum format

These functions return 'sum' values for a sequence of fixed time periods. For example, CWS# (calendar week sum) calculates a series of weekly sum values for each full calendar week between the start and end dates. The format is:

Function#(Expression)

Where:

Function is a calendar function code, for example, CWS#

Expression can be a series mnemonic, a combination of series, a nested function or an Ennn number (an expression stored in Expression Builder)

See also

Average format

Calendar functions