Expression error

[Anonymous]

I have to show the list of customers with more than one invoice on the same day, I am able to show that by using the below expression

if(count({<datekey={'20180601'},CustomerCode>} DISTINCT InvoiceNumber)>1, CustomerName)

I need the TotalInvoiceAmount, but if am adding this column it is showing all the customers.

[sasiparupudi1]

Change the expression to

If(Column(1)>=2,sum(TotalInvoiceAmount))

or

If(Count>=2,sum(TotalInvoiceAmount))