ABS, absolute value (as a column)

  • Type: Inserted as a column
  • Description: Returns the absolute value (removes minus signs) from numbers in the last column.
  • Range:
    • Columns: Last column
    • Rows: Each row
    • Measures: First measure
  • Syntax:
abs(sum(d-1, 0, m1))
  • Sample crosstab:

 

Example

In the sample crosstab above, we would like to calculate the absolute values (remove the minus signs) from the numbers in the 2025 column.

Adding the calculation as a column, we get this result:

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

Comments

0 comments

Please sign in to leave a comment.