MIC Calculation

[former_member308137]

Hi Team,

Need your help to know the formula as per below requirement. I have 4 MIC and last MIC is 4 and its having "calculated" tick mark.

MIC MAX MIN Results

MIC1 200 90 99

MIC2 500 50 499

MIC3 200 200 200

I want to calculate the Max value i.e. 499 and Min value i.e. 99 and then difference of Max & Min value i.e. 499 - 99 = 400. This 400 value should get update in MIC4.

Please help to know the formula for this so that we can put in MIC4 level and system should calculate automatically once we MIC1 to MIC3 update with results.

[former_member42743 · Accepted solution]

Because the min or max can come from any one of three mics you would need a custom Z formula parameter. You can than specify the formula as Z1cccc where Z1 is the formula parameter and cccc is the first characteristic to be considered.

The Z1 parameter would have a function module behind it. The formula would be Z10030 for example. It would assume to start at 0030 characteristic up to the characteristic number of the calculated characteristic. So in this case below, it would consider and characteristic in the plan between 0030 and 0059.

• 0030 MIC 1
• 0040 MIC 2
• 0050 MIC 3
• 0060 - calculated MIC

If at a later date you added characteristic 0045 it would automatically be included in the calculations.

If I understand what you want it would copy all the values of each mic into a list, take the MAX and MIN and do the subtraction.

Craig

[former_member308137 · Accepted solution]

Hi Craig,

Greetings!!!

Thanks for quick help on this.

Yes,your understanding is correct. I will do custom FM and will assign and test it. I was planning to do by some standard way but its seems that it wont work. But now I will go for custom FM as per your suggestion.

Thanks.

[ycam · Accepted solution]

Hi Craig,

I'm trying to implement this solution as I have the same requirement as Satish but I'm facing the following issue :

In customizing, if Z1 is associated to a function Module then the formula does not accept any parameters like Z10010 (it throws error message RN011 ) . Only Z1 is accepted but I can't then specify the MIC to start from.

Is there something I'm missing ?

Many thanks,

Y.C

[former_member42743 · Accepted solution]

I'm not sure. It's been ages since I did this.

In config, where you did added the Z1 FM, did you do the second step and define what value to take?

It might be since you didn't define what type of result and where to get the value, it won't allow you to specify a characteristic.

Craig