on 11-07-2008 11:08 AM
Hello all,
I am currently developing a DESKI report that will tell me in which month a supplier has put through a price increase and what the value of the price increase is (%), by product reference (SKU).
The data provider pulls in the following fields from the universe:
- suppliername
- SKU
- SKU description
- Period (format is yyyymm)
- purchase price
I have also put prompt conditions on suppliername and on Period to run the report on specific suppliers and timeframes.
I have been trying to do this in a crosstab, with the Period running across the top.
For the price increase I need a formula that calculates this:
(Price (current month) / Price (previous month)) -1
This doesn't work in a crosstab however, because I can't create a formula that 'looks up' the price of the previous month
Any ideas?
Alain,
I think the formula should look like
=(<price> - Previous(<price>)) / Previous(<price>)
Cheers,
Harry
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.