Error of Using Count in the Expression

[#1]

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 )

[#2 · Accepted solution]

Hi,

Use IF Statement.

If(Count(OrderedCustomers)=1,Sum(NetPrice))

Thanks

[#3]

Thankyou umeshjadhav