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

    Count Customesr only when ...



      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.