Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a problem with double quotes in double quotes within set analysis. I
read two posts:
double quote
wrapper in double code issue in set analysis
and
but none of them answer my question.
I have the following code:
=count({$<
SALES_ID={"=SUM({<MY_DATE =
{">=$(=Date(MakeDate(year(min(MY_DATE))-1,Month(min(MY_DATE)),Day(min(MY_DATE)))))<=$(=Date(MakeDate(year(max(MY_DATE))-1,Month(max(MY_DATE)),Day(max(MY_DATE)))))">}SALES_AMOUNT)>0"},
MY_DATE = {">=$(=Date(MakeDate(year(min(MY_DATE))-1,Month(min(MY_DATE)),Day(min(MY_DATE)))))<=$(=Date(MakeDate(year(max(MY_DATE))-1,Month(max(MY_DATE)),Day(max(MY_DATE)))))"}
>} DISTINCT SALES_ID)
The user select a date interval MY_DATE. Then I take this interval and I
define the same interval but FOR THE PREVIOUS YEAR (minus 1 year). For
instance: the user select 1.1.2015 - 31.9.2015 --> MY_DATE = 1.1.2014 -
31.9.2014. I want to count different products SALES_ID in this period of time.
Additionally, I want also count only that SALES_ID which have some sales
amount > 0 (it can happen that I have SALES_ID with SALES_AMOUNT=0 in the
period 1.1.2014 - 31.9.2014 and i don't want to count them).
The problem is that I have double quotes within other double quotes (in the first part of my code). I tried
to change in brackets or other accent like ``. I also tried escape sequences, but it doesn't work.
SOME IDEAS??
Thanks in advance.
try single qotes on the inner part ' instead of "
try single qotes on the inner part ' instead of "
I tried but it doesn't work..
I was wrong. It works perfectly. Thanks