Derived Calculation

Enter an algebraic formula that specifies the quantity, price, hours, or a value associated with a rule.

These examples illustrate the syntax for possible derived calculations:

Segment References

S3 indicates segment 3.

S3=Piston= indicates segment 3 in item Piston.

Trigonometric and Logarithmic Functions

SIN(20) indicates the sine of 20.

COS(S3) indicates the cosine of segment 3.

TAN(S4) indicates the tangent of segment 4.

ARC(S3) indicates the arctangent of segment 3.

LOG indicates log to base 10.

LN indicates natural log.

2**5 indicates an exponent, 2 to the fifth power.

Substring

SUBSTR(S10,1,4) indicates that the substring from segment 10 starts at the first position of the string and includes the first 4 positions.

Concatenations

CONCAT(S3,S4) combines the values of segments 3 and 4.

External Fields

Specifies the fields from non-configurator tables that you want the system to access as part of a calculation. Use the ampersand character followed by the field name. For example, &T2AMTU(WD) indicates an amount field in the Item Supplemental Database table, and the WD data type.

External Programs

Specifies that a program external to the JD Edwards EnterpriseOne system from Oracle is to be used for the calculation. Enter the name of the external program and EXTVAR in the Derived Calculations field.

Smart Parts

'P'S4 indicates a smart part number P2000 when the value of segment 4 is 2000.