I have an issue with one of the tables that I am creating. Find the table below. I have formulas calculating the values from Q1 - Q4 and Fy depending on the Year and the Period selected (say Year : 2016 and PEriod : 5 )
I need to create one more column which should recalculate the formulas for Pevious Period.
In the formula there are other variables that are dependent on the period too. Eg: Target Period will be >=1<=4 for Period 4 and will be >=1<=5 for Period 5.
Is there any way I can force the Period value to be Period -1 in the begining on the caluculations so that I will be able to re use my formulas?
