Rolling 12 months bases on a Date selection

[#1]

Hi,

I'm looking for an set analysis statement that gives me the rolling 12 months Sales bases on an OrderDate selection (listbox)

This expression:

=sum(if(OrderDate>addmonths(vDate,-12) and OrderDate<=addmonths(vDate,0), LineSalesAmount)) (//vDate = variable)

.....into set analysis.

I hope you can help me!

[#2]

Use the following expression:

=sum({<OrderDate={"$>vStartDate<vDate"} >} LineSalesAmount)

where,

vStartDate = addmonths(vDate,-12)

[#3]

I got a 0 as result

[#4]

I guess, it could be due to the values of the variables. Have you defined the variables correctly. Check the values of the variables 'vStartDate' and 'vDate' and see if they are different.

[#5]

vDate = 1-1-2009

vStartDate = 1-1-2008

but the expression gives still 0.

[#6]

Can you check with this:

=sum({<OrderDate="{$>$(vStartDate)<$(vDate)}" >} LineSalesAmount)

The quotes were placed wrongly in the last expression

[tresesco]

Hi,

try the set analysis like this,

=sum({<[OrderDate]={">$(vStartDate)<$(vDate)"}>} LineSalesAmount)

Hope this would help,

Regards,

tresesco

[#8]

Hi,

Still 0 as result.

I tried the expression below for testing vStartDate en VDate and this is working fine.

=

sum(if(OrderDate>=vStartDate and OrderDate<vDate, LineSalesAmount))

[#9]

can you attach an example document. I will check the expression in the file.

[#10]

Hope you can find what I am doing wrong!