In Bex Calculate result as Multiplication

[Former Member]

Hello,

in order to create a overall yield on several workcenter the formula is like that

Yield 1 * Yield 2 * Yield 3 * ....... * Yield n

in the bex in calculate result as i have only summation, average, min max;

how can i add a new functionality as multiplication ?

Regards

BW 3.5

[Former Member]

This message was moderated.

[Former Member]

Hello,

i would like that global yield will bee 50%

because this three workcenters are in lines

it means the piece comes to Workcenter 1 and after to Workcenter 2 & to Workcenter 3 ..

so the gobal yield compare the pieces entered at to Workcenter 1 to the number of piece out of the last workcenter

so in that case 1000 Pce / 500 pce so a yield of 50%

regards

[Former Member]

can't you make a new key figure that is the "global yield" and is calculated as you describe?

using a calculate result as won't work and even if it did work when workcenter is displayed it would not when it7s removed from the drill-down

[Former Member]

Hello,

use cell editor could be a solution but all list are dynamic it's possible to have 2 or 10 workcenter

regards

[Former Member]

why ??

1000 800 yield 80% = 800/1000

800 800 yield 100% = 800/800

800 500 yield 62,5 % = 500/800

-

---

2600 2100 yield 50% 2100/2600 = 81%

how can the total be 50%???????????

[Former Member]

Hi

In 3.5 you can use the Cell editor concept

where you can multiply the data from the previous cells

Like

Cell1* Cell2

Cell*Cell3

Regards

N Ganesh

[Former Member]

hello let me write an example

plant Workcenter consumed parts good parts yield

Plant 1 Workcenter1 consumed 1000 good 800 yield 80%

Plant 1 Workcenter2 consumed 800 good 800 yield 100%

Plant 1 Workcenter3 consumed 800 good 500 yield 62,5 %

-

---

Plant 1 Workcenter consumed 2600 good 2100 yield 50%

0.8 * 1 * 0.625 = 0,5 --> 50% i have to multiply the yield in order to have the good yield !

regards

[Former Member]

Hi Poupin,

You have to create a caculated keyfigure for this making a caculation over there.You cant do it by 'calculate result as'.

Hope this helps

Regards

Karthik