8 Replies Latest reply: Jun 24, 2014 9:09 AM by Tobias Meyer RSS

    sum() with many filter with which function?

      Hi,

      I've many IDs with Amount like:

       

      ID, Amount

      400000, 4500

      ...,...

      999999,4000

       

      Now I need to sum() all the ID from: 400000 - 59999 AND 677000  AND 688000, except 494500, 494700,494800


      How can I express this?

      Do you have an idea ?