Concat inside another concat

[jduluc12]

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.

[swuehl]

Maybe try a set expression like

=Concat({<cust = e({<amount = {"*"}, date={">='01/12/2017'<='02/06/2017'"} >} cust) >} DISTINCT cust)

[jduluc12]

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.

[swuehl · Accepted solution]

Are there any current selections?

=Concat({1<cust = e({<amount = {"*"}, date={">='01/12/2017'<='02/06/2017'"} >} cust) >} DISTINCT cust)

[jduluc12]

I was using 1 with e so it was not working.

Now it works.