MCVA Report

[former_member198268]

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

[former_member198268]

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

[former_member198268]

Hi everyone,

I have found the answer myself.

Thanks a lot.

Regards,

Sophia Xavier

[Former Member]

Hi Sophia,

If you do not mind, How did u solve this problem?

Because i have a problem in SIS report, so may be your solution can help me.

Thanks in advance,

Ahmed