How to calculate a formula using value prior to current year?

3.93K views
0

One of my calculated nodes requires data from 5 months prior.  The formula works but only reads data in the current year.  How do I configure ‘data sorting’ so that the prior year data is used in the current year formula but doesn’t impact my current year planning?

Answered question
0

Hi Currently ValQ does not have time intelligence.

This can still be achieved by using combinations of CPI and IF and the DSSeries funcitons.

Answered question