Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.
Try in below format
=aggr(if(count({<datekey={'20180601'}>} DISTINCT InvoiceNumber)>1, CustomerCode),CustomerCode)
I need the totalinvoiceamount for this customers.
sum(aggr(if(count({<datekey={'20180601'}>} DISTINCT InvoiceNumber)>1, CustomerCode),CustomerCode,TotalInvoiceAmount))
Can you share your app?
Sorry I cannot share the app. These are the two customers having more than one invoice, but total invoice amount is 0
May be try
Sum({1}(Aggr(sum({1} InvoiceAmount),CustomerCode))
or post some sample data
try this ...
if(sum(aggr(count(distinct InvoiceNumber), CustomerCode, InvoiceDate)) > 1,
sum(aggr(count(distinct InvoiceNumber), CustomerCode)) )
I have added invoice amount. It should show A and C only but now showing all the three customers.