9 Replies Latest reply on Aug 9, 2012 7:45 PM by Dimitri.B

    Sum distinct

    limbs
      IDMonth

      Value

      P1JAN4.2
      P1JAN4.2
      P1JAN4.2
      P1JAN4.2
      P1JAN4.2
      P1JAN4.2
      P1JAN4.2
      P1JAN4.2
      P1JAN4.2
      P1FEB

      3.8

      P1FEB

      3.8

      P1FEB

      3.8

      P1FEB

      3.8

      Dear all,
      I would like to calculate the sum P1 for distinct value (4.2+3.8 = 8.0), may i know how's the formula work? Currently if using aggregation, it will return a total value of 53. Any suggestion?
      Regards,
      lim