Skip to Content
author's profile photo Former Member
Former Member

MCVA Report

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 16, 2008 at 04:50 PM

    Hi everyone,

    I have found the answer myself. 😊

    Thanks a lot.

    Regards,

    Sophia Xavier

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 23, 2008 at 12:02 AM

    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
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.