3 Replies Latest reply: Feb 5, 2013 4:47 AM by Vishwaranjan Kumar RSS

    Using Distinct to sum multiple data entries

      Hi there

       

      I have some data that looks like this

       

      HESAProject CodeApplication ValueStaff Name
      CharityPR11000Dave
      CharityPR11000Keith
      CharityPR11000Bruce
      Research CouncilPR25000Bruce
      Research CouncilPR25000Dave

       

      My requirement is to produce the application value for each HESA classification. The problem is that the total for PR1 is actually 1000 (not 3000 by simple sum). It is repeated for each staff member involved.

       

      Basically I need an expression that only sums one value for each project code. I think I can use Distinct in the sum formula for this, but cannot seem to produce a valid expression.

       

      Can anyone help?