Count based on a formular - not on a field

[pyrodirk]

Hi,

please have a look at the following table:

In a textfield i want to count the number of customers who have an OVERALL > 120,00 Euro ( must be 4 - 1 ,2,3,4) . The problem here ist that OVERALL is a formular definded as Sum(TOTAL <CUSTOMER_NR> TOTAL_SUM ) not a field . How to do that in this case ?

Regards

Dirk

[#2]

Have you tried something like this in your text box?

=if(Sum(TOTAL <CUSTOMER_NR> TOTAL_SUM )>110,Count(DISTINCT CUSTOMER_NR))

[pyrodirk]

Yes , of course - you can put it in the last text Field on my demo application. I get wrong results (6) or a - whe i try to adjust the 110 to somethig like "110,00 €" , because that was my previous problem when counting against a value.

Dirk

[swuehl · Accepted solution]

Try

=Count(  {$< CUSTOMER_NR={"=Sum(TOTAL_SUM)>110"}  >} DISTINCT CUSTOMER_NR )