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
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