Valid Operators and Functions

The following operators and functions can be used for specification of calculation formulas for BOM columns:

• Operators

• Addition +
• Subtraction -
• Multiplication *
• Division /
• Exponential operator ^
• Mathematical und trigonometrical functions
• Absolute value of a number log(No.)  
• Logarithm of a number to a given base abs(No.)
• Arc-sine of a number log10(No.)
• Logarithm of a number to base 10 asin(No.)
• Arc-cosine of a number sin(No.)
• Sine of a number acos(No.)
• Arc-tangent of a number sinh(No.)
• Hyperbolic sine of a number atan(No.)
• Cosine of a number sqrt(No.)
• Positive square root of a number cos(No.)   
• Hyperbolic cosine of a number tan(No.)
• Tangent of a number cosh(No.)  
• Raises base e to the power of the number given as argument tanh(No.)
• Hyperbolic tangent of a number exp(No.)

IF … THEN … ELSE-constraints can also be used for formula definition.