3 Replies Latest reply: Mar 5, 2012 2:15 AM by jagan mohan rao appala RSS

    Summarizing a range of accounts

      I have a table that looks something like this:

       

      Account     Amount

      1511          100

      3010          230

      4020          110

      8990          130

      4010          150

       

      If I want to summarize the amount on accounts 3000 to 3999 and 4000 to 4029, how would you write that in an expression?

       

      Best regards

      Thor