Expression not working

[#1]

Hi All,

The expression that I am trying to use to calculate the MTD is not working :

(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)

Data I am using was Last reloaded on 24 Sep 2014.

Dates I am getting is 23 Sep CY and 24 LY whereas I want 23 Sep CY as well as for last year.

Can anyone help.Its Urgent.

Thanks

[geert_gelade]

Could it be the equal sign marked in red ?

(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)

[#3]

Hi,

Thanks for the reply.

I don't think that's an issue.

Thanks

[senpradip007]

Have you tried as Geert advised?

[#5]

Hi,

I think its working however I am still verifying.

Thanks