Skip to Content
Former Member

### Calculated Characteristics

Hi,

I have a quick and easy question.

Here's the scenario: I have 4 MICs under ONE operation in an Inspection plan. I want to enter individual results into MIC 1, MIC 2 and MIC 3...then for MIC 4, I want the result of MIC 4 to be the AVERAGE of the first 3 MICs.

Hope this makes sense.

Any help would be greatly appreciated.

Thanks again.

-Bruce

##### Add comment
10|10000 characters needed characters exceeded

### 5 Answers

• Best Answer
Former Member
May 10, 2010 at 07:49 PM

FF,

Thanks so much for your help.

I did what you said and Now I get a new error "Variable C00010 in items 7 and 8 can not be identified

Message no. RN011" At least I'm getting somewhere now..>LOL

##### Add comment
10|10000 characters needed characters exceeded
• Craig S Craig S

So Bruce,

Did you finally get this working? Was the issue multiple values in one of the characteristics? I'm always curious as the actual solution.

FF

• Apr 28, 2010 at 07:02 PM

Set the 4th MIC as a calculated charac by setting the calculated charac control indicator.

When you add the MIC to an inspection plan, it will prompt you for the formula. You must make sure MIC 4 always comes after Mic 1,2,3.

If MIC 1,2,& 3 are listed as charac 0010, 0020, and 0030 respectively in your plan, the formula in Mic 4 would be

(C00010C00020C00030)/3

When recording results, you cannot valuate MIC 4 until MIC's 1,2,& 3 are valuated and locked.

FF

##### Add comment
10|10000 characters needed characters exceeded
• Former Member

By using Cal char error msg .

### Variable C00010C00020C00030 in items 19 and 20 can not be identified

Message no. RN011

pls explain char 40 setting in detail as cal char.

• Former Member
May 10, 2010 at 07:17 PM

Gents,

I have tried everything. I have no idea why it keeps giving me an error. Now it's giving me some kind of Syntax error..>Complaining about lines 60 and 61 in the table? When I double click on the error...i just get Syntax error between columns 60 and 61

Message no. RN002

In the first field I put "C0" In the second field I put the formula "(C00010C00020C00030)/3"

Is there something in Config i'm missing? Is there a function module that is supposed to be set in Config?

Thanks so much

##### Add comment
10|10000 characters needed characters exceeded
• Yes.. don't do that.

Put the formula, (what you have on the second line), and place it in the first line.

The two formula fields are really just text strings. You don't have to have anything in the second field. If you do, the system attempts to joing them together. So to the system your formula is "C0(C00010C00020C00030)/3"

Which if it attempts this at all is the mean value of characteristic(C00010C00020C00030)/30. Whatever that might come out to?

Just put (C00010C00020C00030)/3 on the first formula line. Leave the second line blank.

FF

• May 14, 2010 at 01:24 PM

Hi Bruce

All the advise the previous people have given is 100% accurate - hopefully it has helped you solve the problem.

Try also changing the sampling procedure valuation for all characteristics to "700 Mean Value within Tolerance Range".

I have the exact same calculation as you in one of our inspection lots and it is working perfectly with valuation 700 and the formula (C00010C000020C00030)/3.

Good luck

M

##### Add comment
10|10000 characters needed characters exceeded
• Former Member
May 26, 2010 at 06:09 PM

Hey FireFighter,

Thanks for asking. Yes, I did get this working. It was actually in the config. C0 was set up to "require" a Function Module. After I turned that off and just put "C0" in the value...It worked great.

So all of your answers were spot on.

Thanks so much.

-Bruce

##### Add comment
10|10000 characters needed characters exceeded
• Thanks for the update. I'm glad it turned out to be something simple. I don't think I would have ever come up with the suggestion to check config to see if someone mucked around with that peice of config!

FF