2 Replies Latest reply: May 22, 2013 5:12 AM by Amuthabharathi Subramanian RSS

    Error of Using Count in the Expression

      Hi,

      I Want to get the customers details who purchased only once.All details about the customer purchase in orders table i took the customerID from orders table as OrderedCustomers. To find the customers  and amount of purchase who purchase only one  time i use the following expression

       

       

       

       

      =Sum({<Count(OrderedCustomers)={1}>}NetPrice)

       

       

       

       

       

      But it shows Error can any one help how to get the customers purchase only onetime.(Net price is the amount where UnitPrice * Quantity - Discount )