The POST function helps you shift or move a number, such as a sales amount or order quantity, forward or backward along a dimension. If multiple values are offset to the same target item in the dimension, the POST function adds them together.

You could use POST to determine when stock arrives at a warehouse given a certain lead time.

POST(Value to post, Offset amount [, List]) 

ArgumentData typeDescription
Value to postNumberThe value to post to the target item in the dimension.
Offset amountNumber

The number of line items to offset forward or backward within the dimension. This can be a positive or negative number, or zero.

  • A positive number posts a value into a later item in the dimension.
  • A negative number posts a value into an early item in the dimension.
  • A zero value keeps the value in the same item. 
List (Polaris-only)List

The list over which the function should operate.

See Calculation engine functionality differences.

The POST function returns a number.

  • In Polaris, you can't use the POST function for line items that have the Formula summary method. In the Classic Engine, you can.
  • In Polaris, you can use the POST function over any dimension, by including an additional argument. In the Classic Engine, you can't. Where, if the additional argument isn't included, the function defaults to Time as the dimension.

POST(Orders, Lead time)

The time range for any values used as arguments for the POST function must match the time range of the result line item.

This example uses the POST function to offset the Orders line item for each month based on the Lead time line item.


Jan 22Feb 22Mar 22Apr 22May 22Jun 22Jul 22
Orders50102070357550
Lead time3-1-21-30-4
POST(Orders, Lead time)3035505070750

You can use the POST function in combination with the IF THEN ELSE function to create a conditional formula. However, when you do this, ensure you position the two functions appropriately within your formula.

In this example, separate line items contain the Value to post, the Offset amount, and the Boolean condition that determines if a value should be posted.

When using the POST function within the IF THEN ELSE, the value is only posted in items where the Boolean condition is TRUE. However, the posted value can come from any of the values in the Value to post, irrespective of its Boolean condition.

When using the IF THEN ELSE within the POST function, the formula can contain the IF THEN ELSE function as part of the Value to post argument. This makes sure that values are posted in all items. However, the posted value can only come from the Value to post where its Boolean condition is TRUE.


Jan 22Feb 22Mar 22Apr 22May 22Jun 22Jul 22
Value to post124102040100
Offset amount11-12-21-2
Boolean condition

true

true

true


true


IF Boolean condition THEN POST(Value to post, Offset amount) ELSE 0052200100
POST(IF Boolean condition THEN Value to post ELSE 0, Offset amount) 042001040