formula for MIC in inspection plan

[Former Member]

Hello Experts,

I have to use formula like Max(MIC1615 and MIC1616) for MIC 1617 in inspection plan.

How can I implement this formula in inspection plan?

Please guide me

Thanks in advance

Best Regards,

Umesh

[former_member382153 · Accepted solution]

Hi Umesh,

Please try with below formula for MIC C

IF CA0020>CA0030 THEN CA0020 ELSE CA0030

Thanks,

Amol

[Former Member · Accepted solution]

Hi Amol,

Thanks for solution

It works

I think that we have to think like ABAP logic

Thanks

Umesh

[former_member185450]

Hello Umesh,

Please create the MIC1617 with control indicators--> Calc formulae tick mark

Assign this MIC in the plan then double click on this MIC --> Quantitative data-> Assign the formula i.e. Max(MIC1615 and MIC1616)

while making the results recording system will calculate the results as per the formulae defined in the MIC1617

Regards,

Venkatesh..

[Former Member]

Hello Venkatesh,

I have maintained formula as per your instruction but have error as .

Variable MAX in items 3 and 4 can not be identified.

Message no. RN011

Thanks,

Umesh

[former_member185450]

Hello Umesh,

you shouldn't keep your characteristic names as it is you should refer it as C00010 and C00020 as per your assignment in the quality plan

please go through the below thread for better understanding

how to use the formula function in the MIC and plan

https://scn.sap.com/thread/1672782

Regards,

Venkatesh

[Former Member]

Hello Venkatesh,

I have already checked that thread.

My scenario is like below

I want valid max. value for MIC say C from MIC A & MIC B

for example-

MIC A have max value say 100

MIC B have max value say 150

Need formula MIC C that it will calculate valid max value from MIC A & MIC B

in this for MIC C have value 150

How to set formula for this scenario?

Please guide

Thanks,

Umesh

[JVK]

Hi Umesh,

You need to assign the third characteristic - MIC C as the calculated characteristic and when you press enter it will ask for the Formula - IF A00010 > A00020 THEN A00010 ELSE A00020.

0010 / 0020 - line item no. of the MIC A or MIC B.

During the results recording you need to valuate & close MIC A & B, and then click on calculate button, whichever is higher will be copied to the MIC C.

Hope this will resolve the issue.

Thanks,

Vamsi