Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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 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)

...