Spread of data (as a column)

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

 

Example

Now we add a calculated column (Spread of data (column)) - and this is the result:

 

 

 

 

 

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

Comments

0 comments

Please sign in to leave a comment.