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

Spread of data (as a row)

Avatar
Niels Thomsen
  • Type: Inserted as a row
  • Description: Calculates the difference between maximum value and minimum value.
  • Range:
    • Columns: Each column
    • Rows: All rows
    • Measures: First measure
  • Syntax:
max(0, all, 0) - min(0, all, 0)
  • Sample crosstab:

 

Example

Now we add the calculated row (Spread of data (row)) to see the spread of data each year, each measure.

The resulting table looks like this:

 

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