5 Replies Latest reply on Sep 12, 2019 10:58 PM by Gousia Mulla

    Difference between first and last quarter

    Gousia Mulla

      Hi All,

       

      I want to calculate the difference between 'last quarter' and 'first quarter' for selected year@, if year selected in the filter is < current year.

       

      For eg :

       

      Q1     Q2     Q3     Q4

      6        8        1        4

       

      if you select year which is smaller than current year then it should display Q4-Q1 which is 4-6 = -2

      If current year is selected,  it should display 'current quarter' - 'previous quarter' which is Q2-Q1 which is 8-6 = 2

       

      Thanks in advance.

       

      Regards,

      Gousia