6 Replies Latest reply: Sep 19, 2012 5:48 AM by Dirk Enders RSS

    Count Customesr only when ...

      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