Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a database with customers and sales in quantity and value. How can I sum the values and put it in a text of those sales that exceed a certain amount of quantities?
For some reason returns zero (0) as a result
Hi,
If you want sales with quantity>4, try
=sum({<Quantity={">4"}>} Sales)
Thank you for your immediate answer but i forgot to mention that i have multiple entries for every customer and i need to define only those customers with a total sales quantity over a certain amount
Try with
=sum({<Customer={"=sum(Quantity)>4"}>} Sales)
Try like:
=sum({<Customer={"=Sum(Sales)>100"}>} Sales)
For some reason returns zero (0) as a result
can you share a sample?
Propably i was doing something wrong.
Now is working.
Thank you all