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!