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