List with concat as modifier

[Anonymous]

Hi all

I am trying to produce a list of names with the following function:

concat({<Order_Channel_Name={"=sum({1<[Transaction_Date.autoCalendar.Year]={""$(vLY)""}, [Transaction_Date.autoCalendar.Month]={""$(vMonth)""}>}Value-Tax)>0"}>}distinct Order_Channel_Name, ',')

This actually works and returns a comma separated list of values (Order_channel_name)

Now I want to put these values in the following function:

sum({<Accumulator_Type={'RETAIL'},Order_Channel_Name={---Put above function here!!!}>}Value-Tax)

Apparently copying the first function and pasting it into the second doesn't work.

Any ideas?

[Anil_Babu_Samineni]

Perhaps this?

sum({<Accumulator_Type={'RETAIL'},Order_Channel_Name={$(=Chr(39) & concat({<Order_Channel_Name={"=sum({1<[Transaction_Date.autoCalendar.Year]={""$(vLY)""}, [Transaction_Date.autoCalendar.Month]={""$(vMonth)""}>}Value-Tax)>0"}>}distinct Order_Channel_Name, ',') & Chr(39))}>}Value-Tax)

[Anonymous]

I see what you are doing with Chr(39). But putting it in the beginning and the end is not enough, it needs to be around each word that is concatenated. I tried the separator to be 'Chr(39),Chr(39)' but it doesn't work. It just adds the actual string "Chr(39)" before and after the comma.

Any other ideas?

[Anil_Babu_Samineni · Accepted solution]

My bad, Here it is?

sum({<Accumulator_Type={'RETAIL'},Order_Channel_Name={$(=Chr(39) & concat({<Order_Channel_Name={"=sum({1<[Transaction_Date.autoCalendar.Year]={""$(vLY)""}, [Transaction_Date.autoCalendar.Month]={""$(vMonth)""}>}Value-Tax)>0"}>}distinct Order_Channel_Name, Chr(39) & ',' & Chr(39)))}>}Value-Tax)

None of them won't help, I may ask sample application

[teempi]

Hi,

Maybe like this:

sum( {<Accumulator_Type={'RETAIL'}, Order_Channel_Name={"=sum({1<[Transaction_Date.autoCalendar.Year]={""$(vLY)""}, [Transaction_Date.autoCalendar.Month]={""$(vMonth)""}>} Value-Tax) > 0"} >} Value-Tax)

-Teemu