# GETMEASURE

The GETMEASURE function can be used to select data from a native measure based on its index. It should be used with an aggregate function like SUM or AVERAGE. 

## Syntax

```javascript
GETCOLBETWEENPERIODS(index, type)
```

## Arguments

index– Order of the native measure in the AC/PY/PL/FC bucket. Required.

type– Can be AC/PY/PL or FC. Required.

## Example

```javascript
GETMEASURE(1, "AC")
//Returns the first native measure in the AC bucket

GETMEASURE(2, "PY")
//Returns the second native measure in the PY bucket
```

<figure><img src="https://content.gitbook.com/content/sB9HAei8v4FfKkH9M4gw/blobs/yYQFlvRSFvosMM6C6Pu6/image.png" alt=""><figcaption><p>GETMEASURE</p></figcaption></figure>