YerMonth - 100

[#1]

Hi Everybody:)

I've got problem with period YearMonth - 100 (Year-1)

In the selection user can choice YearMonth wchich aren't countinous period. For exmaple: 200903, 200906, 201011

I want to evaluate:

Sales for this period - no problem - in expression I don't use any YeraMonth

Sales for this period - 1 Year - I don't know how

If this period is continous - no problem

YearMonth={">=$(=((Left(Min(YearMonth), 4)-1)&(Right(Min(YearMonth),2))))"}*{"<=$(=((Left(Max(YearMonth), 4)-1)&(Right(Max(YearMonth),2))))"

but what if isn't countinous....????

[#2]

Try this

sum( {$< X= { ">=201001 <=201003",">=201007 <=201011" } >} X)

[#3]

I can't point in expression cocrete YearMonth. This point users in current selections

[#4]

Up....

[#5]

Hi Magda,

please see the attached example (the lower part) for more help.

Good luck!

Rainer