6 Replies Latest reply: Apr 22, 2014 9:31 AM by Herbert Chitate RSS

    Summation on Distinct Customer

      Hi All,

       

      I have a customer database which has balances at various dates, i.e. a client can have more than one entry reflecting balances as at that date. I am developing an app that looks at total debt and then introduce various dimensions. How do I do a summation of client's balances (say area dimension) , but based on the last entry for that client, i.e. based on the last balance (by date). Lets say the fields are Customer, Date of Balance, Amount, Area.

       

      Many Thanks

       

      HerbieC