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