2 Replies Latest reply: Jul 10, 2014 10:06 AM by Levente Botha RSS

    testing if sum of rows = 0 then sum

      Hi all!

       

      I don't know how to search for my specific problem. I have to make some charts about inventory. I need quantity and price for every week in the past, since january. The problem is with price because summing the quantity is 0 but summing the price is not. How can i do something like

          sum(if(sum(quantity)=0, 0, price)).

       

      Its aggregation in aggregation, is there any chance for this?

       

      Sorry for my poor enlglish, maybe its understandable.

       

      Thanks in advance!