on 01-04-2008 7:03 AM
Hi All,
We are using BEx Query Designer to create a query having one formula variable Stock on Hand as a cumulated value (along the columns).
Now we need to use this cumulated value in another formula variable. Is this possible to do? If not could you please suggest an alternate for the same?
Stock on hand (for any given week) = (Total Receipts Total Demand) + Stock on Hand (for previous week).
Inv. Carrying Cost (for any given week) = Stock on hand (cumulated values as above) * per unit inv. cost
Data for Total Receipts, Total Demand and Per unit Inv. Cost is present in the infocube at daily level. A sample report template has been given below:
Week W1 W2 W3
Total Demand 10 10 25
Total Receipts 20 0 15
Stock on Hand 10 0 -10
Per unit Inv. Cost 2 2 2
Inv. Carrying cost 20 0 -20
Hi
I think formule can contain either the cumulative or another formula also.
try it out. Good luck.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi,,
yes you can use cumulated values.. if you have this field as a separate column in the structure, then u can use it in the formula any time..
Regards,
Shakeel.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
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.