5 Replies Latest reply: May 22, 2018 7:34 AM by Sunny Talwar RSS

    Calculating annualized revenue

    siddharth soam

      Hi

       

      I want to calculate annualized revenue i.e. (sum of revenue for previous 4 quarters with respect to my selection)

        

      Fiscal YearQuartersRevenue
      FY17Q142
      FY17Q226
      FY17Q389
      FY17Q434
      FY18Q132
      FY18Q253
      FY18Q375
      FY18Q440

       

       

      For example if I select  FY18 Q3 the expression should return me the summed up revenue of FY18 Q3,Q2,Q1 and FY17 Q4 i.e. 194.

       

      Also if there is no fiscal year selection by default it should consider  FY18 .