RollupActive
Use this function to put the current calculation block into a state where changes to values are tracked for later rollup processing. The rollup is limited to the area defined by the calculation block and must be turned off before the end of the calculation block. ROLLUPACTIVE only rolls up the changes, unlike the ROLLUP function.
Note: A ROLLUP function cannot be contained within a ROLLUPACTIVE block.
Syntax:
ROLLUPACTIVE ("ON" | "OFF")
where:
- ROLLUPACTIVE provides two options. Select one of the following:
| Value | Description |
|---|---|
ON |
Starts tracking changed cell values for rollup purposes. |
OFF |
Performs the rollup based on the changed cell values since the RollupActive was turned on. |
Note: "ON" and "OFF" must be enclosed in double quotation marks.
Syntax example:
CalculationBlock (Accounts)
RollupActive("ON")
A1 = $UserInput$
A2 = A1 "*" .25
RollupActive("OFF")
A4 = A3 "*" .75
EndCalculationBlock()
This would calculate A1, A2 and then propagate the changes to A1, A2 to all affected parents in the DataArea, then calculate A4.