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

Difference between first column and second column (as a column)

Avatar
Niels Thomsen
  • Type: Inserted as a column
  • Description: Calculates the difference between two values, first column and second column.
  • Range:
    • Columns: First column minus Second column
    • Rows: Each row
    • Measures: First measure
  • Syntax:
sum(d1, 0, m1) - sum(d2, 0, m1)
  • Sample crosstab:

 

Example

In the table above we want to calculate the difference between 2024 Revenue and 2023 Revenue - this is done by adding Difference first column - second column (column).

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