Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am trying to apply the year filter to the column in the left but unfortunately i'm not getting any results. (Its zero)
Below is the set analysis string im applying:
sum({1<DATE(MNDATE,'YYYY')={'$(vRepYrCrnt)'}>} ENDTOT)
MNDATE has starting dates of each month, like (20160101.... 20161201) and my variable vRepYrCrnt=2016
Your help will be much appreciated.
Regards
Ilyas
Create a year field in the script:
LOAD MNDATE,
Year(MNDATE) as Year
...
FROM ...;
and then this
Sum({1<Year={$(=vRepYrCrnt)}>} ENDTOT)
Create a year field in the script:
LOAD MNDATE,
Year(MNDATE) as Year
...
FROM ...;
and then this
Sum({1<Year={$(=vRepYrCrnt)}>} ENDTOT)
Huh... why this didn't strike to me? Yeah this is the way ahead and it works! Thanks Sunny!