Previous quarter values

Options
tampara.dora
tampara.dora Member, ALL USERS Posts: 5 New Contributor
in Planning & Modeling

I have the following line items- A,B,C. I need to create a new line item D which should take previous quarter values if C=0. PFA screenshot. 

Tagged:

Comments

  • tampara.dora
    tampara.dora Member, ALL USERS Posts: 5 New Contributor
    If I give PREVIOUS(C) it takes Q4FY22 value in Q1FY23. What I want is match Q1FY22 to Q1 FY23, Q2FY22 to Q2FY23 and so on.
  • tampara.dora
    tampara.dora Member, ALL USERS Posts: 5 New Contributor
    Thank you!! That worked. But there is one other issue. I also want the same Q1FY22 values for Q1FY23, Q1FY24, Q1FY25
    Q2FY22 values for Q2FY23,Q2FY24, Q2FY24, Q2FY25
    Q3FY22 values for Q3FY23,Q3FY24, Q3FY24, Q3FY25
    Q4FY22 values for Q4FY23,Q4FY24, Q4FY24, Q4FY25

Categories