9 Replies Latest reply: Feb 18, 2015 11:40 AM by Jyothish KC RSS

    Searching sums

    Frank Mogavero

      Greetings,

       

      I would like to search sums. I have vouchers which have separate line amounts. I would like to be able to search by the amount of the voucher. This gives me the amounts that I can search, but I am not sure how to search them.  =sum([LineAmount],[VoucherNumber])

       

      I would ike to be able t search for vouchers between $100.00 and $500.00.

       

      I have been trying to solve this for too long. Has anybody ever done this before?

       

      Thanks,

      Frank