SUMCASES computes the sum of the values of a series of cases of its argument parameter in the current solution

Syntax

SUMCASES(Parameter, FromCase, ToCase)

Arguments

• Parameter to be calculated in the multi-case solution (or in an object)
• FromCase case number (row of a table) to start with 
• ToCase case number to stop

Remarks

1. The SUMCASES function can be used to compute e.g. the advancing average of Parameter or as a primitive form of integration by summing the values of Parameter from all cases from FromCase up to the current case. When current case > ToCase, the sum up to ToCase is returned.

Examples

B# = SUMCASES(A, 3, 6)

returns the following result for a variation of parameter A from 1-10 ():

Quick links: Function overviewAttribute overviewConstants overviewDimensions overview