- Type: Inserted as a column
- Description: Calculates last column value as index of second last column value.
- Range:
- Columns: Last column as index of Second last column
- Rows: Each row
- Measures: First measure
- Syntax:
if sum(d-2, 0, m1) = 0 then 0 else sum(d-1, 0, m1) % sum(d-2, 0, m1)
- Sample crosstab:
Example
Now we want to calculate a revenue index in 2024, based on the 2023 revenue.
This is what the resulting table looks like:
Comments
Please sign in to leave a comment.