# SETCOLUMNSORT

Sort a specific column in ascending or descending order. Enable absolute sorting to ignore signs and sort based on magnitude.

### Syntax

```javascript
SETCOLUMNSORT(column, type, isAbsoluteSort)
```

## Arguments

column – The column to sort. Use the [COLUMNS ](https://docs.inforiver.com/formula-syntax/identifiers/columns) identifier to select a specific column. Required.

type - Asc or Desc. Required.

isAbsoluteSort - Set to TRUE to enable absolute sort. Required.

### Example

```
SETCOLUMNSORT(COLUMNS.[Qtr 1 > Actuals],"Asc",TRUE)
//Sorts quarter 1 actuals in ascending order with absolute sorting enabled
```

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FkHQjB14tyGMSBhF5AB2g%2Fimage.png?alt=media&#x26;token=9317b5d8-dd84-46ca-92b0-ec8c90977336" alt=""><figcaption><p>SETCOLUMNSORT script</p></figcaption></figure>

Notice how the sort order changes when absolute sort is enabled and disabled.

<figure><img src="https://3062809325-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FEbkCXCUXmtUq5tcnUtZE%2Fuploads%2FXtMR7lHowFZbFkrHVUE9%2FUntitled%20Project.gif?alt=media&#x26;token=f213a92e-b85a-4e81-b5b4-ce0138bcba31" alt=""><figcaption><p>Changing the sort order with scripts</p></figcaption></figure>