Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
try:
if(sum(quantity)=0, sum(price), sum(quantity))
if(sum(quantity)=0,0,sum(price)) did the trick, Thank you!