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.

[tripatirao]

Do you wants to customer name in expression or dimension

are you using pivot table

and y are entering hard coding date.

Please elaborate ur requirement, it would be better if you provide the sample data

[Anonymous]

Customer name is not must,but customer code.

Am using straight table.

The requirement is I have show an alert if any of the customer has invoiced more than once in same day(so date should be vtoday) after every reload.

[shiveshsingh]

Try in below format

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

[Anonymous]

I need the totalinvoiceamount for this customers.

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

[shiveshsingh]

Can you share your app?

[Anonymous]

Sorry I cannot share the app. These are the two customers having more than one invoice, but total invoice amount is 0

[sasiparupudi1]

May be try

Sum({1}(Aggr(sum({1} InvoiceAmount),CustomerCode))

or post some sample data

[Anonymous]

try this ...

if(sum(aggr(count(distinct InvoiceNumber), CustomerCode, InvoiceDate)) > 1,

  sum(aggr(count(distinct InvoiceNumber), CustomerCode)) )

[Anonymous]

I have added invoice amount. It should show A and C only but now showing all the three customers.