sales and 1997
You should be able to do this using:
= Where (=1998)/ Where (=1997)
or…
I have a report which uses 2 linked data providers to return sales for “this year” and sales for “last year” (where ‘this year’ & ‘last year’ are derived from the system date) I can then do this kind of comparison by using a formula which refers to each data provider. (e.g. =<Sales Amount(This Year)>/<Sales Amount(Last Year)>). I can’t remember if I had a good reason for doing this?
Justin
I have a simple crosstab report with one measure, Sales Amount. It has 7 rows, one for each product, and 2 columns: one for 1997, one for 1998. I want to add a % increase column that calculates the comparison between 1998 sales and 1997 sales. Is there an easy way to do this ? I’ve tried the ‘previous’ function but it seems to want to take the increase of Product n over Product n-1.
This is the way I would like it to calculate:
1997 1998 % increase
Product 1 10 15 50%
Product 2 10 20 100%
Product 3 20 10 -50%
Product 4
Product 5
Product 6
Product 7
Thanks,
Matthew
Listserv Archives (BOB member since 2002-06-25)