system
#1
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)
system
#2
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 (BOB member since 2002-11-08)
system
#3
Please, take a look at the Reporter FAQ…
Andreas (BOB member since 2002-06-20)
system
#4
Thanks for that.
rowk (BOB member since 2003-09-18)