How to calculation Stock Price

[Former Member]

Hi Expert,

I want to calculation amount in BEx. Key values are profit Center,plant,material ,but I am just want to display Profit center,

who can tell me how to do this report in BEx.Amount using formula(Quantity * Standard Price) MultiProvider (0IC_C03 & 0MAT_PLANT)

[Former Member]

Hide your Key figure: right click key figure select properties and select "Hide(can be shown)" or "Always hide" from the hide drop down box and then select OK.

Amount: Create Key figure "Quantity" and "Standard Price", Add "New Formular" by right click Key figure menu and define it as Quantity * Standard Price. You can then hide "Quantity" and "Standard Price" by changing their properties as described above.

[Former Member]

thank you every one help,but this result is not i want

because amout item splite by material item ,I want to total amount

ex.

Result:

1000/BU04

-

---

-

---

(Material item A hide) (Material item B Hidi)

91,000.00 9000.00

Corrent:

1000/BU4

-

---

100,000.00

[Former Member]

Hi Wei,

not sure about the version of BI being used, but how about using the aggregation as "Before aggregation" and then display by profit center?

Naveen.A

[Former Member]

Thank you every body assistance,this issue was been resolved.

[Former Member]

Hi

Create a Calculated Keyfigure(CKF) : Quantity * Standard Price.

Create another Restricted Keyfigure : using the CKF and Restrict the Infoprovder to : 0IC_C03 & 0MAT_PLANT.

You can hide the Formula if you dont want to display.

Regards, Hyma

[rathy_moorthy2]

Hi,

U can right click on the key figure sturcture in columns and create a new formula.

And give in definion as

(Quantity * Standard Price).

Hope it helps.

Regards,

Rathy