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
- An easy way to use this function is using the Remainder option accessed from orange button attached to each expression.
- An error will occur if you attempt to use the remainder function in more than one neighboring branches.
Examples
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):
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