# Search # POST

Returns the value in a line item from a future or previous period based on a positive or negative offset value.

The offset for each period determines where the source value is to be posted to. POST can use a second line item as the offset amount, which could result in more than one source value being posted to a target period.

Since the offset can vary by period, this can be used to add up selected periods in the timescale.

POST only works on number-formatted line items.

## Syntax

`POST(x, n) `

where:

• x: Line item: value to be returned
• n: Offset amount

## Format

Input Format Output Format

x: Line item formatted to a number

n: Number

Number

## Arguments

The function uses the following arguments:

• x: Line item: Numeric
• n: Number: Numeric line item, property, or expression.

## Constraints

The function has the following constraints:

• The offset for each period determines where the source value is posted. Negative value pushes to later periods, positive value retrieves POST earlier periods.
• POST can result in more than one source value being posted to a target period.
• POST is only applicable to numbers.
• The time range providing arguments to a line item must match the time range for the result line item. Any formula that conflicts with this rule will be rejected. For more information, see Search page.
• A non-time series function, used as a sub-expression of this function, must use the same time range as the line item to which the formula is applied. Combining time series functions and non-time series functions with a time range could return an unexpected result or an error message. For more information, see Time Ranges and Time Series Functions page.

## Excel equivalent

• No Excel equivalent

## Example

The formula:

`POST(x, 3) `

returns the value in line item x to 3 time periods in the future. The formula:

`POST(x, -2)`

returns the value in line item x to 2 time periods in the past. The formula:

`POST(x, n)`

returns the value in line item x offset to the value n. The example below shows how two cells are pushed to the same destination cell. The values in row n are editable. The x value in column Mar15 is posted to column Feb 15 in row Post n periods later by the value n in Mar 15.

At the same time, the x value in column Feb15 is posted to cell Feb 15 in row Post n periods later by the value n in Feb 15.