Hi All,
I am facing an issue with set as I am trying to create MTD by using below expression:
(sum({<Month_No_SM1={"$(=num(month(max(Date_SM1))))"},Year_SM1={"$(=max(Year_SM1))"},Date_SM1={"<$(=max(Date_SM1))"}>}QUANTITY_SM1)
-
sum({<Month_No_SM1={"$(=num(month(max(Date_SM1))))"},Year_SM1={"$(=max(Year_SM1)-1)"},Date_SM1={"<=$(=date((AddYears(max(Date_SM1),-1)),'MM/DD/YYYY'))"}>}QUANTITY_SM1))
/
sum({<Month_No_SM1={"$(=num(month(max(Date_SM1))))"},Year_SM1={"$(=max(Year_SM1)-1)"},Date_SM1={"<=$(=date((AddYears(max(Date_SM1),-1)),'MM/DD/YYYY'))"}>}QUANTITY_SM1)
and its picking up the wrong dates.
Data I have till 24 Sep 2014 however its giving me the figures of 23 Current Year and 24 for last year.
Can anyone help?
Thanks
