Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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, ',')
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, ',')
It works!! Thanks a lot!!