Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
You can create different field like
Load
Month(TRA_DATE) as Month
Num(Month(TRA_DATE)) as NumMonth
From Location;
And use NumMonth field in SET analysis expression.
Try with
Sum({<year={2013},month={' $ (=Month(Today()) ) '},day={2}>}TRA_QTY)
Or
Sum({<year={2013},month={" $ (=Month(Today()) ) "},day={2}>}TRA_QTY)
SUM({<year = {'$(=Year(Today()))'}, month = {'$(=Month(Today()))'}>}TRA_QTY)
SUM({<year = {'$(=Year(Today())-1)'}, month = {'$(=Month(Today())-1)'}>}TRA_QTY)
Dont you only use " when its a search string? When it should be between two months or so?
Try below
Sum({<year={"$(=year(today()))"},month={"$(=Month(today()))"},day={"$(=day(today()))">}TRA_QTY)
Regards
ASHFAQ
thanks anand, I have another problem how can i get previous month?
H try below
Sum({<year={2013},month={' $ (=Month(Today())-1 ) '},day={2}>}TRA_QTY)
Regards
ASHFAQ
Try with
Sum({<year={2013},month={' $ (=Month(Today())-1 ) '},day={2}>}TRA_QTY)
Hi Anand,
my variable name is currentMonth. How can i include it?
currentMonth=month(today())
i guess its a string?
Sum({<year={2013},month={ '$(currentMonth)' '},day={2}>}TRA_QTY)