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.
Syntax
POST(Value to post, Offset amount[, List])
Arguments
| Argument | Data type | Description |
| Value to post | Number | The value to post to the target item in the dimension. |
| Offset amount | Number | The number of line items to offset forward or backward within the dimension. This can be a positive or negative number, or zero.
|
| List (Polaris-only) | List | The list over which the function should operate. See Calculation engine functionality differences. |
The POST function returns a number.
Calculation engine functionality differences
| Behavior | Classic | Polaris |
| Line items with Formula summary method | Can be used for line items with Formula summary method. | Can’t be used for line items with Formula summary method. |
| Usage over different dimensions | You can’t use POST over any dimension. The function defaults to Time as the dimension. | You can use POST over any dimension, by including the additional argument, List. |
Syntax example
POST(Orders, Lead time)
Constraints
The time range for any values used as arguments for the POST function must match the time range of the result line item.
Examples
General example
Combine POST with IF THEN ELSE
