4 Replies Latest reply: May 15, 2018 12:59 AM by siddharth soam RSS

    Want to calculate annualized revenue

    siddharth soam

      Hi I want to calculate annualized revenue . My data structure is as follows:

       

        

      Fiscal YearQuartersAccounting Period
      FY17Q11
      FY17Q12
      FY17Q13
      FY17Q24
      FY17Q25
      FY17Q26
      FY17Q37
      FY17Q38
      FY17Q39
      FY17Q410
      FY17Q411
      FY17Q412
      FY18Q11
      FY18Q12
      FY18Q13
      FY18Q24
      FY18Q25
      FY18Q26
      FY18Q37
      FY18Q38
      FY18Q39
      FY18Q410
      FY18Q411

       

       

      Expected Outut-Q1,Q2,Q3

       

      I want to compute an expression where if my count of accounting period corresponding to a quarter <3,then all quarters before it should be displayed. So for example in the above table count of accounting period corresponding to Q4 is 2, then my output should display  Q1,Q2,Q3