Remainder

Syntax

Remainder(Expression )

Description

Calculates the remainder between an Expression and the sum of the values of neighboring (sibling) branches. The parameter specifies the total to which all neighboring branches should sum.  In other words, the function is calculated as

Expression - Sum of Other Neighboring Branches.  

Tips:

Example

Consider two neighboring branches in a demand tree in which you are specifying the changing market share of Kerosene and LPG cooking technologies (in percent):

 Branch

Expression

Household\Cooking\Kerosene

Interpolate(2000, 50, 2020, 30)

Household\Cooking\LPG

Remainder(100)

Remainder(100) is evaluated as follows:

2000 = 50.0
2010 = 60.0
2020 = 70.0