Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to use below expression but it gives error,
please help me to correct it
count({$<Date(MY_date,'YYYY-MM-DD')={$(=Max(MY_date)-1)}>}Country)
you should set the left hand side of the expression in the script and then need to compare the same
Date(MY_date,'YYYY-MM-DD') set this in the script and then use
or try once like this :
count({$<Date(MY_date,'YYYY-MM-DD')={"$(=Max(MY_date)-1)"}>}Country)
You can't put an expression in the LHS section of set analysis, that has to be a field (script generated). Hence, you better try to format the date in the RHS of your set comparison, like:
count({$<MY_date={"$(=Date(Max(MY_date)-1), 'DD-MM-YYYY') "}>}Country)
Change the date format as it is with My_date field.
Hi,
You cannot do any formatting or any calculations in Left hand side of the set analysis expression, instead you have make the changes in the RHS as required like below
count({$<MY_date={"$(=Date(Max(MY_date)-1, 'YYYY-MM-DD'))"}>}Country)
Note: YYYY-MM-DD replace with actual MY_Date format, so that the expression works.
Regards,
Jagan.
try this
count({$<MY_date={"$(=date(Max(MY_date)-1,'YYYY-MM-DD'))"}>}Country)
You connot use expressions like "set_identifier". I suggest you to prepare additinal field with suitable format of date in script and use it in set analysis. Moreover, using numeric presentation of date is more effective then text format of date.