Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Bex OverAll Result issue

Hello Experts

I have a requirement as follows.

AS IS

CalMonth Plant Matrial Material1 Scrap Overall Qty Scrap %

01.2010 ABC 123 1231 10 250 4%

1232 25 250 10%

Result 35 500 14%

14% = 35/250 * 100

To Be

CalMonth Plant Matrial Material1 Scrap Overall Qty Scrap %

01.2010 ABC 123 1231 10 250 4%

1232 25 250 10%

Result 35 500 7%

7% = 35/500 * 100

Over all Qty is calclated as a Exception Aggregation - First Value (based on Doc no).

whereas the Result is considered as "Calculate Result as - Total"

But when the system calculates result for Scrap % for Result line it considers over all qty as 250 instead of 500. I want i to consider 500 What can be done?

Pls suggest.

Not what you were looking for? View more on this topic or Ask a question