Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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?

0 Replies