Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 )
Hi,
Use IF Statement.
If(Count(OrderedCustomers)=1,Sum(NetPrice))
Thanks
Hi,
Use IF Statement.
If(Count(OrderedCustomers)=1,Sum(NetPrice))
Thanks
Thankyou umeshjadhav