Sum

Syntax

Usage 1

Sum

Usage 2

Sum(Branch:Variable) or
Sum(Branch:Variable, LastYear) or
Sum(Branch:Variable, FirstYear, LastYear) or

See also: Total, Subtotal

Summary

In Usage 1, Sum calculates the sum of the values of all other immediately neighboring branches with the same data units excluding the value of the current branch and any branch values calculated as a Subtotal.

In Usage2 (in which at a minimum a branch:variable name is passed as a parameter), the function calculates the sum of values over the specified set of years in the current scenario and region).  

• When no FirstYear or LastYear parameters are supplied the function calculates the sum of the values from the base year to the current year.  This is equivalent to writing:  Sum(Branch:variable, Year, EndYear)
• When no first year is supplied, the function calculates the sum from the base year to specified last year.

Sum is an alias for Total