4 Replies Latest reply: Jan 24, 2018 5:56 AM by vivek Moningi RSS

    Quarter over Quarter Analysis

    vivek Moningi

      Hi All,

       

      I have a requirement where i need to derive column based on a specific column. for better understanding consider below example.

       

      TradeLevelDateQuarter
      1230/09/20173
      1330/06/20172
      1331/03/21071

       

      I need to derive status column so, in the above example Trade No = 1, for quarter 3 it need to compare the level of Quarter 2 and give it as 'TO'.

       

      for the same trade no =1 , for quarter 2 when compared to quarter 1 as the level is same it should show same as status.

       

      The above calculation I need in back end script.

       

      Summary: for every trade number it should compare current qtr with previous Qtr and derive the status.

       

      The o/p should look like:

       

      TradeLevelStatusDateQuarter
      1230/09/20173
      13TI30/06/20172
      13Same31/03/21071

       

      The level should always need to be compared with previous quarter value.

       

      Thanks,

      Vivek

       

      Message was edited by: vivek Moningi