Blox Help Center | SHIFT() function

SHIFT() function

Shift a value forward or back through time periods

Rob Markwell

Last Update 4 maanden geleden

🗒️ Description

The shift formula allows a user to shift a reference indicator's value backwards or forwards through a number of time periods.

✏️Syntax & variables

“Indicator name” : string. Name of the reference indicator to shift
number_of_period : number or reference to another indicator - number of periods to shift the values

✅ Expected result & examples

Forward monthly shift by 6

Assuming the model is monthly - the “6” shifts the values from Indicator 1 by 6 months into indicator 2

The first 6 months of Indicator 2 are filled with 0 as the value.

Formula

Negative monthly shift by 2 months :

Assuming the model is monthly - the “-2” shifts the values from Indicator 1 by 2 months into indicator 2 in a negative way

Formula :

Dynamic shift:

Assuming that data values are in integer format which means it has both negative and positive values. In this example we are shifting values by B . so it will simply add A+B and shift the values.

Formula:

Was this article helpful?

0 out of 0 liked this article