REBOOK
Example
Before:
Revenue:
Year | Segment | Revenue |
---|---|---|
2020 | MINI | 100 |
2020 | COMPACT | 50 |
2020 | LARGE | 10 |
After:
Example 1:
REBOOK('Revenue', “Segment”, “MINI”, “LARGE”) =
Year | Segment | Revenue |
---|---|---|
2020 | MINI | 0 |
2020 | COMPACT | 50 |
2020 | LARGE | 110 |
With this formula, the value measure of 'MINI' is rebooked to 'LARGE'.
As LARGE already had a revenue of '10', the rebooked value of '100' is added (=110).
Calculation:
Year | Segment | Revenue |
---|---|---|
2020 | MINI | 100 (-100) |
2020 | COMPACT | 50 |
2020 | LARGE | 10 (+100) |
Example 2:
REBOOK('Revenue', "Segment", [“MINI”, “COMPACT”], “LARGE”) =
Year | Segment | Revenue |
---|---|---|
2020 | MINI | 0 |
2020 | COMPACT | 0 |
2020 | LARGE | 160 |
With this formula, the value measures of 'MINI' and 'COMPACT' are rebooked to 'LARGE'.
The 'OldValue' measures are combined and add up to the measure of 'LARGE'.
Calculation:
Year | Segment | Revenue |
---|---|---|
2020 | MINI | 100 (-100) |
2020 | COMPACT | 50 (-50) |
2020 | LARGE | 10 (+100+50) |
Example 3:
REBOOK('Revenue', “Segment”, “MINI”, “LARGE”, “NEQ”)
Year | Segment | Revenue |
---|---|---|
2020 | MINI | 100 |
2020 | COMPACT | 0 |
2020 | LARGE | 60 |
As the FilterOperation is set to “NEQ”, all measures of the levels not equal to the “OldValue” (MINI) are rebooked to the “NewValue” (LARGE).
Calculation:
Year | Segment | Revenue |
---|---|---|
2020 | MINI | 100 |
2020 | COMPACT | 50 (-50) |
2020 | LARGE | 10 (+50) |