Applying a Period Offset in Formulas (KPIs)

By default any account line, category or non-financial line you add to a formula will reference its transactional or cumulative value for the reporting or forecasting period selected in the Card’s settings or in the forecast formula. Applying a Period Offset allows you to reference past periods instead, enabling you to create calculations such as Opening Bank Balance and Monthly Growth in Revenue.

Written by Ross MacLeod

About

By default, any Account Line, category or non-financial Line you add to a Formula will reference its transactional or cumulative value for the reporting or forecasting period selected in the Card’s settings or in the Forecast Formula. Applying a Period Offset allows you to reference past periods instead, enabling you to create calculations such as Opening Bank Balance and Monthly Growth in Revenue. In this example we’re going to demonstrate how to apply a Period Offset in order to create a simple calculation – Opening Bank Balance.

Formula Builder

With the Formula Builder or a Forecast Formula open, we first need to select our Bank Accounts line from the Account/Category box. This is where we’ll find the entire Chart of Accounts for the selected Organisation:

Screen Shot 2017-01-17 at 13.52.47

Locate Further Options

After selecting your Bank Accounts line you’ll notice a small arrow in the corner of the newly added item. Clicking this exposes further options, including the facility to select either Transactional or Cumulative as your data set, and the option to apply a period offset:

Screen Shot 2017-01-17 at 13.54.56

Select Period Offset

Enter ‘1’ against the ‘Period(s) ago box. This will cause your Formula to reference the value of your Bank Accounts line one period prior to that of whichever reporting or forecasting period/s is selected (as shown in the Settings section of the Card):

Screen Shot 2017-01-17 at 13.57.22