- Type: Inserted as a column
- Description: Calculates the difference, as a percentage, between two values, current row and previous row.
- Range:
- Columns: Last column
- Rows: Current row minus Previous row
- Measures: First measure
- Syntax:
if sum(d-1, -1, m1, 0) <= 0 then 0 else (sum(d-1, 0, m1) - sum(d-1, -1, m1)) / sum(d-1, -1, m1)
- Sample crosstab:
Example
Here we want to calculate the percent difference between current row and previous row (months) for last column.
Notice that the first row sums to 0, since there is no previous row.
Comments
Please sign in to leave a comment.