6 Replies Latest reply: Apr 14, 2014 12:25 AM by vijeta sharma RSS

    Calculating Values

    vijeta sharma

      Hi all,

      I am having requirement as, my data is

         Month, Start, End
           01, 130, 100
           02, 110, 120

           03, 100, 100
           04,90,100
           05,100,110
           06,100,140
      at the time of calculating quarters I want output as

      Quarter Start End

      q1     130     100

      q2     90     140

       

      Here start value for quarter is value of starting month for respective quarter & same for end value