1 Reply Latest reply: Apr 25, 2013 2:54 PM by Srini VEERAVALLI RSS

    Need sum on all coulumns except for one coulumn needs max value

    999602
      Hi Gurus,

      I have a requirement like:

      Say I have 3 columns like C1,c2,c3.
      On day1 the record values are 100,150,200
      On day2 the record values are 100,150,300

      End result ..for column C1 and C 2 I should get sum of them
      so the result for C1 as per the above values: 200
      c2=300

      But for C3 column, I should get only maximum value..like 300 (not sum)...
      Using case statement by setting a flag on max report date.. we can do this ..Is there any other that this can be achieved. (In ETL or RPD or Front end)

      Thanks.