BusinessObjects Board

Trouble creating variable

Hi there,

I know there’s probably a simple answer to this but…

I’m trying to create a variable that is Nett Sales for the period sep 2001 to Aug 2002 - the period is in separate months ie 200109 200110 etc.

I’m using a when statement which only seems to allow me to chose one specific period rather than a lot of them.

Here’s the formula I’m using:

= Where (<Period (yyyymm)>= (“200109, 200110, 200111, 200112, 200201, 200202, 200203, 200204, 200205, 200206, 200207, 200208”))

Any help would be greatly appreciated.

Thanks,

Row


rowk (BOB member since 2003-09-18)

Row,

A Quick way is to create a Flag kinda variable using IF THEN ELSE and have 1 for your periods and 0 for other periods.



=IF ((<Period (yyyymm)> IN ("200109, 200110, 200111, 200112, 200201, 200202, 200203, 200204, 200205, 200206, 200207, 200208")) Then 1 Else 0

Then you can use that Flag variable in the NettSaleValue variable.



=<Nett Sale Value> Where (<Flag>= 1)

Sri


Sridharan :india: (BOB member since 2002-11-08)

Please, take a look at the Reporter FAQ


Andreas :de: (BOB member since 2002-06-20)

Thanks for that.


rowk (BOB member since 2003-09-18)