variable problem

[#1]

Hi,

how can i add a variable like "month(today())" to month in below set analysis. thanks

Sum({<year={2013},month={May},day={2}>}TRA_QTY)

[its_anandrjs]

Try with

Sum({<year={2013},month={' $ (=Month(Today()) ) '},day={2}>}TRA_QTY)

Or

Sum({<year={2013},month={" $ (=Month(Today()) ) "},day={2}>}TRA_QTY)

[MK_QSL]

SUM({<year = {'$(=Year(Today()))'}, month = {'$(=Month(Today()))'}>}TRA_QTY)

SUM({<year = {'$(=Year(Today())-1)'}, month = {'$(=Month(Today())-1)'}>}TRA_QTY)

[#4]

Dont you only use " when its a search string? When it should be between two months or so?

[ashfaq_haseeb]

Try below

Sum({<year={"$(=year(today()))"},month={"$(=Month(today()))"},day={"$(=day(today()))">}TRA_QTY)

Regards

ASHFAQ

[#6]

thanks anand, I have another problem how can i get previous month?

[ashfaq_haseeb]

H try below

Sum({<year={2013},month={' $ (=Month(Today())-1 ) '},day={2}>}TRA_QTY)

Regards

ASHFAQ

[its_anandrjs]

Try with

Sum({<year={2013},month={' $ (=Month(Today())-1 ) '},day={2}>}TRA_QTY)

[#9]

Hi Anand,

my variable name is currentMonth. How can i include it?

currentMonth=month(today())

[#10]

i guess its a string?

Sum({<year={2013},month={ '$(currentMonth)' '},day={2}>}TRA_QTY)