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.