@inputpd( [Time period reference])

Definition

Input period

This function is useful when using an optional time period reference, usually a lead or lag, although absolute period references are possible.

Returns

Returns the input period driving the value for the period being calculated. This may be the period that is being calculated, if it is an input period.

Example

For example:

@inputpd( -1 )

You can reference the preceding input period, even if that period is a different type from the current period, which enables returning some types of lagged data.

This formula:

@Vxxxx(-1)

returns the value of Vxxxx from the previous period of the same type.

This formula:

@Vxxxx(@inputpd(-1))

returns the value of Vxxxx from the preceding input period.