Skip to Content
0
Former Member
Dec 01, 2005 at 01:49 PM

average value of KF

88 Views

Hi All

I am pulling Material waise Batchwise Good receipt with one KF in percentage. (percentage of Nickel in Matrial).

I have only material as characteristic in the Cube. charecteristic Batch is not part of cube. While clubbing the records on Material in the Cube this percentage value is getting added( standard Cube feature). I however dont want it to be added (as percentage exceeds 100).

I want average of percentages. Is it possible someway or the other.

E.g

Records in PSA

Material Batch percetage of Nickel

100 A 74.9%

100 B 74.5%

100 C 74.4%

Record in Cube

Material Batch percetage of Nickel

100 A 223.8%

The expected value is

Material Batch percetage of Nickel

100 A 74.6%

How do I reach to the expected value

Please advice

Thanks in advance

Regds

PB