Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a data set like this
cust date amount
cust1 01/01/2017 100
cust2 02/05/2017 200
cust3 03/04/2017 300
I need to print the name of cust in a text box which does not have any amount within a certain time period
here is what i am trying
=concat({1}if(not match(cust,
concat({1}total if( aggr(sum({<date={">='01/12/2017'<='02/06/2017'"}>}Amount, cust)>0, chr(39)&cust & chr(39) &chr(44)))),
cust) & chr(10))
This gives me all customers instead of giving cust1 and cust3.
when i try this
concat({1}total if( aggr(sum({<date={">='01/12/2017'<='02/06/2017'"}>}Amount, cust)>0, chr(39)&cust & chr(39) &chr(44)))) seprately then
it gives me the right values which is cust2
somehow when i put this expression in another concat then it return null values.
can anyone help please?
Thanks.
Are there any current selections?
=Concat({1<cust = e({<amount = {"*"}, date={">='01/12/2017'<='02/06/2017'"} >} cust) >} DISTINCT cust)
Maybe try a set expression like
=Concat({<cust = e({<amount = {"*"}, date={">='01/12/2017'<='02/06/2017'"} >} cust) >} DISTINCT cust)
Hi Stefan
When i replace e() with p() then i get cust2 but when i use e() then i do not get expected value cust1, cust3.
Are there any current selections?
=Concat({1<cust = e({<amount = {"*"}, date={">='01/12/2017'<='02/06/2017'"} >} cust) >} DISTINCT cust)
I was using 1 with e so it was not working.
Now it works.