Count Customesr only when ...

[pyrodirk]

Hi

i can reduce my problem to a table with three fields , Customernumber, ordernumber, total_sum.

Now i want to know in a text field, how many customers (count) i have, who's total amount is greater than 1500.

I tryied something like this

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

but the result is still 0. What i am doing wrong here.

Regards

Dirk

[#2 · Accepted solution]

Try:

=Count({$<TOTAL_SUM={'>1500'}>} DISTINCT CUSTOMER_NR)

Check that all your fields match exactly.

[pyrodirk]

Thanks for the very fast reply, but still the result is 0.

[MayilVahanan]

Hi

Try like this

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

or

If(Total_Sum > 1500, count(Distinct Customer_Nr)

Hope that helps

[pyrodirk]

No , it is still not working....

[MayilVahanan]

Hi

Can you provide a sample file?

[pyrodirk]

Hi ,

as i build the example application i found the error. The reason why it was not woring was, that i format the TOTLA_SUM as Money so the part of the look like =Count({$<TOTAL_SUM={'>1500,00 €'}>} DISTINCT CUSTOMER_NR).  So thanks again for the help.

Dirk