5 Replies Latest reply: Mar 1, 2013 11:58 AM by Robert Ebner RSS

    sum-if-function in combination with a where-function

    Robert Ebner

      Hi all,

       

      I want to use the sum-if-function in combination with a where-function. Is this possible?

      The problem is that I want to use the where-function on another field.

       

      My solution doesnt work:

       

      sum(rangeonly(if(field1>6000 and field1<6999,field2)),  where (field3) like 'd%')          as field4

       

      Thank you for your answers!