Month convert to Number

[#1]

Hi All,

I have a formula which is like

sum

({$<month={num(month(addmonths(today(),-3,1)),'00')}, BUCKET5={"A.*"}>}CURROSSGD)

I got a variable called month. Another variable is BUCKET5. I want to sum up the CURROSSGD.

I would like to get the month value equal to 3 month ago from current month (such as Dec 2014 as today is 17/03/2015.

But anything wrong with the formula above? Why the num is black? Qlikview keeps telling me I got errors.

Anyone can help me out on this?

Thanks a lot.

[#2]

Try now

=sum({$<month={"$(=num(month(addmonths(today(),-3,1)),'#,##0'))"}, BUCKET5={"A.*"}>}CURROSSGD)

[#3]

Hi

Try this

=sum({$<month={"$(=num(month(addmonths(today(),-3))))"}, BUCKET5={"A.*"}>}CURROSSGD)

[mukesh24]

Hi

create variable as

vMonthNum = num(month(addmonths(today(),-3)))

Use above variable in expression

({<month = {"$(vMonthNum)"},BUCKET5 = {"A*"}>} CURROSSGD)

[jagan]

Hi,

Try like this

Month(AddMonths(Today(), -3))

Regards,

Jagan.

[vvvvvvizard]

You cant use the Months variable if it contains Jan , Feb , Mar , April ect as Dec -3 is not march.

You should rather use the another variable which contains Month and year together  Dec-14 , Jan15 , Feb-15.

Now you can say Month(AddMonths(Period, -3) )