Hi MM gurus,
When I run the standard report MCVA (Tcode MCVA-Vendor Analysis Basic lots), there are 38 fields in the report output. Its a drill down report by Inspection Type->Vendor->Plant->Month. When I drill down to the Month level, I have about 4 line items for a particular selection but for certain fields like Skip Rate, Rejection Rate and Mean lead time, the value displayed in the totals line on the top is not the summation of the individual line item.
For eg: For a particular selection, at the month level the value of the rejection rate,Skip rate and Mean Lead time for four different months and the total value are as follows:
Month Skip Rate Rejection Rate Lead time
Total 70.968% 12,903% 6894DAY
09.2008 0,000% 0,000% 8030DAY
10.2008 95,455% 0.000% 6919DAY
11.2008 100,000% 100,000% 25,708DAY
12.2008 0,000% 75,000% 0,921DAY
If you can see, the total is not the sum of the line items. What is the logic behind the calculation of the total value for these kinds of fields??
It would be great if you could explain this.
Thanks in advance.
Regards,
Sophia Xavier
Hi Ahmed,
If your question is about calculating the total,then here's your answer.
In all the cases, total will simply account to the sum of all the line items. But look out for the exact calculation or formula for the entity. For eg.Skip Rate is equal to No. of Skips to Total No. of Skips.
So, if there are two line items then the total would be ( No. of Skips for line item 1 + No. of Skips for line item 2) / ( Total No. of Skips for Line item 1 + Total No. of Skips for Line item 2).
The calculation of total would be in a seperate include.
Hope this helps.
Thanks,
Sophia Xavier
Add a comment