PERIOD_LOOKUP

A PERIOD_LOOKUP function returns any periods values.

Syntax

PERIOD_LOOKUP(offset, initialValue) - > [number]

Arguments

Datatype

Description

Remarks

This function can only be used after referring a node for which this calculation needs to be done as shown below in the example.
If we give negative number for the offset it will go back to the past periods and vice versa.
Period lookup will only work if there is 1 series (Year). To use it for multiple series PRIOR_SERIES_PERIOD_LOOKUP function should be used along with PERIOD_LOOKUP.

Example 1

Consider a scenario where you want to calculate the closing balance of Non-Current assets by including the monthly movements. Below is the information.

To achieve this, the following formula should be written in the [Opening Balance] node:

[Closing Balance].PERIOD_LOOKUP(-1,30000000)

Closing Balance node name is referred in the formula before using PERIOD_LOOKUP so that the calculation is performed for this specific node values. Since we have mentioned the first period value as $30 million it will take this as January month value. After that it will take the Closing Balance node as the previous period value as we have mentioned -1.

Result

Example 2

Consider a scenario where you have Year 1's Unit price value and Growth rate of Unit price for Years 2 to 5. We need to calculate the current year's price by taking the previous year's price and multiplying it with the growth rate.

To achieve this, the following formula should be written in the [Unit Price] node:

(THIS.PERIOD_LOOKUP(-1,400)*(1+[Growth rate (Years 2-5)])

Result

PreviousTHIS_SOURCE_KEY NextPRIOR_SERIES_PERIOD_LOOKUP

Last updated 1 year ago