This discussion is archived
1 Reply Latest reply: Apr 25, 2013 12:54 PM by Srini VEERAVALLI RSS

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

999602 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points