3 Replies Latest reply: Sep 5, 2014 1:50 PM by Enrique Colomer RSS

    Aggr/Max Question

      I have a data set similar to this:

       

      IDDateStdDayValue
      A1/1/20141100
      A1/2/2014250
      A1/3/201435
      B3/5/20141200
      B3/6/2014250
      C4/1/20141500
      C4/2/20142400
      C4/3/20143300
      C4/4/20144100
      C4/5/2014540

       

      I need a formula that would return the sum of the 'Value' for the maximum 'StdDay' for each 'ID'.  The result for this example should be 5+50+40 = 95. 

       

      Any ideas?

       

      Thanks