10 Replies Latest reply: Feb 27, 2013 4:36 AM by Robert Ebner RSS

    sum(if) for a specific selection

    Robert Ebner

      Hi all,

       

      I want to use the sum(if)-function for a specific selection (all values between 3999 and 5000). My idea is like this, but it doesen't work:

       

      sum(if(booking> 3999 and booking< 5000, cost)) as cost_special

       

      Thank you for your help!