Function as a modifier

[Anonymous]

Hi guys,

I am trying to evaluate this function:

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

I want a list separated with commas of Order Channels that have sales in Last year and same month as selected above 0

I have split the concat and sum functions and they work. It is just when I put them together that they don't.

Any ideas?

Thanks
George

[sunny_talwar · Accepted solution]

May be because of double quotes within double quotes? May be try one of these...

using Escape sequences

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

Or using single quotes instead of double quotes

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

[Anonymous]

It works!! Thanks a lot!!