SUM returns the continuous sum (total) of a specified variable, Cx, each day.

SYNTAX:

SUM(Cx)
where :
Cx is a conditional variable x

NOTES:

The variable to be summed must be specified as a Conditional Variable (use "C" instead of "V")

Specifically, this function adds the previous value to the current day's value.  Use the Force function to seed or start the sum and to reset the Sum. 

Care must be taken to keep this calculation up to date.  For example, if today were June 15th and for some reason you edited a value in the input variable, Cx, for February 14th; then you recalculated the month of June only.  The only values that have been updated to reflect the new value in February are those in June.  You must recalculate the variable containing this function from February 14th to the current date to update all values in between accordingly.

EXAMPLES:

V7 = SUM(C1)

Variable 7 is the continuous sum of variable 1: