Skip to Content

Unable to enter final results for out sourcing test....

Hi Experts,

We have a calculated Characteristic (Char) whose values are based on other Chars.

We have a scenario where if this calculated Char is outsourced to an external vendor, We receive only the final result.

In this case we are now unable to record the result as we do not have the values for chars in the formula.

Is it possible to skip recording values for a calculated char and directly enter its value?

E.g. We have three characteristics

0010 - summarised result Char (Quantitative)

0020 - summarised result Char (Quantitative)

0030 - calculated Char C00010+C00020 (Formula)

If the test is done internally we receive the values for 0010 and 0020 and hence we are able to record results for 0030

But if test is done by an external vendor, he provides values only for 0030. Thus we are unable to record the result.

Please guide me.

Regards,

Imran sharief shaik.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Dec 23, 2016 at 02:50 PM

    Check out this old question:

    https://archive.sap.com/discussions/thread/3481923

    I had thought you could use some IF-Then but my memory eluded me. This question above refreashed it.

    You could try

    IF COO20 > 0 then (COO10/C0020) ELSE C0025

    Another possible option, depending on your required precision, is

    (COO10/COO20+.0001) + COO25).

    With tested values of 14.23 and 2.33 you'll get something like 14.23/2.3301 = 6.1070 instead of the actual value of 6.1073. But if rounded to two decimals which is what you have to do with only two significant digits to start with, you get 6.11 in both cases.

    If you have an external result, the formula winds up as 0/.0001 + COO25 which is 0 + 6.11 = 6.11

    Craig

    Add comment
    10|10000 characters needed characters exceeded

    • Craig S Imran Sharief Shaik

      0060 Assay by HPLC IF (C0050>0) Then C00050 Else (A0010*C0030)/(C0020)

      Change the > to a >=

      0060 Assay by HPLC IF (C0050>=0) Then C00050 Else (A0010*C0030)/(C0020)

      Then set up a policy to enter a -1 if no vendor value is provided. Just document that procedure so its clear.

  • Dec 21, 2016 at 02:29 PM

    I might suggest adding a third characteristic to your formula.

    0010 - summarised result Char (Quantitative)

    0020 - summarised result Char (Quantitative)

    0025 - summarised result from vendor Char (Quantitative)

    0030 - calculated Char C00010+C00020+C0025 (Formula)

    Zero is entered for the values you don't have. If the formula is more involved than what you posted, you have to share that for some other possible ideas.

    Craig

    Add comment
    10|10000 characters needed characters exceeded

    • Dear Craig,

      Above example is working fine for Addition(+),Subtraction(-) and multiplication(*)!

      If the formula having Division(/) for example...

      0010 - summarised result Char (Quantitative)

      0020 - summarised result Char (Quantitative)

      0025 - summarised result from vendor Char (Quantitative)

      0030 - calculated Char (C0010/C0020)+C0025 (Formula) then, because we put zero in char 0010 and 0020. it is undefined to calculate.

      For this above scenario how to handle?

      Regards,

      SIS.