6 Replies Latest reply: Mar 26, 2014 4:32 AM by Herbert Chitate RSS

    Distinct summation

      Hi All,

       

      I have a database with a number of fields, of which the key ones for this question are Customer number, Date & yield. A customer can have a number of entries in this database. I am trying to produce a bar chart for the customer yield by area. The problem I have is that when I do a summation of the yield, I am duplicating, triplicating etc the value of the yield field. I would like to do a summation of the yield field, but based on the last entered value for yield, so that for each distinct customer number, I am only picking up one value of "yield".

       

      Can someone assist with how the expression might look like?

       

      Thank you

       

      Herbert