0 Replies Latest reply: Apr 8, 2013 4:36 AM by cfg_mikael RSS

    How to use Sum with If

      Hi!

       

      I am new at QV!

       

      When I try to do an chart with following expression I get wrong figure. Could somebody help me, what I done wrong?

       

      sum(Sales)                                                  = 100 Correct

      sum(if(BuyingFunction = '1',Sales))             = 120 Not correct, should be 80, because we have other BuyingFunction. How can it be mor than 100?