Formula Calculation while result recording

[Former Member]

While result recording for any Characteristic, the system should calculate some formula to accept or Reject the characteristic.

Eg. Let me take the characteristic as Carbon.

Upper limit 0.100

Lower limit 0.000

My sample size is 3

While result recording I entered the value as

1 0.055

2 0.059

3 0.062

System should calculate the below formulas & the values are in between the tolerance then that should accept or reject the characteristic

X+ H*R

X-H*R

Where

X - Mean value of the Sample

R – Range (Minimum – Maximum)

H- this is the Standard value given by the customer and it should calculate according to following sample size n

Here Same please size is 3 So the value of H is 1.300

Samle(n) (h)

2 6.360

3 1.300

4 0.720

5 0.510

6 0.400

7 0.330

Now the X+ H*R = 0.068

& X-H*R = 0.050

So the values are between the tolerance limits. So the system should propose to accept the characteristic Carbon

Edited by: srinivasan Lakshmanana on Jan 3, 2008 7:11 AM

[Former Member · Accepted solution]

i guess here you will have to define two charcteristics and in one you will have to feed th eresult and for second you will have to give the desired formula so that system will calculate it according to formula defined.

[Former Member]

we can create the characteristic as a calculated characteristic

[Former Member]

Dear Rajesha,

I have given the details

Please go throgh the same and give me the details

Thanks & Regards,

Srinivasan

[Former Member]

please go through the link below, which wil give some idea.

http://help.sap.com/saphelp_47x200/helpdata/en/70/2db434d6e3681ae10000009b38f83b/frameset.htm

[Former Member]

not clear what you are asking for?