Caslculated value in Text Box

[giazitzoglou]

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?

[sergio0592]

Hi,

If you want sales with quantity>4, try

=sum({<Quantity={">4"}>} Sales)  

[giazitzoglou]

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

[sergio0592]

Try with

=sum({<Customer={"=sum(Quantity)>4"}>} Sales)  

[tresB]

Try like:

=sum({<Customer={"=Sum(Sales)>100"}>} Sales)  

[giazitzoglou · Accepted solution]

For some reason returns zero (0) as a result

[sergio0592]

can you share a sample?

[giazitzoglou]

Propably i was doing something wrong.
Now is working.

Thank you all