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

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?

harishramaiah Answered question

Hi Currently ValQ does not have time intelligence.

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

harishramaiah Answered question