4 Replies Latest reply: Feb 4, 2013 4:59 AM by steve peroni RSS

    Help with set analysis

    steve peroni

      Dear all,

      I've to calculate how many customers have sales order value <> 0 in percentage , matching this value with the total customer number


      Total customers:                                        10000

      Total customers with sales order amount:     2000          PErc.  20%


      I've prepared one table where I joined customers and orders and I'm trying without success the following:


      count({<{"=Sum(OrderValue) <> 0"}>} distinct Customer )



      but it doesn't work


      What can I do ? Help please !!


      Thanks in advance