1. TARGIT Community
  2. Documentation
  3. Frontend: Designer, Consumer
  4. Calculations
  5. Predefined Calculations

Difference between current row and previous row (as a measure)

Avatar
Niels Thomsen
  • Type: Inserted as a measure
  • Description: Calculates the difference between two values, current row and previous row, in each column.
  • Range:
    • Columns: Each column
    • Rows: Each row minus Previous row
    • Measures: First measure
  • Syntax:
sum(0, 0, m1) - sum(0, -1, m1, sum(0, 0, m1))
  • Sample crosstab:

 

Example

Here we want to calculate the difference between current row and previous row (months) for each column.. 

Notice that the first row sums to 0, since there is no previous row.

Was this article helpful?
0 out of 0 found this helpful

Comments

0 comments

Please sign in to leave a comment.

Articles in this section

See more