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