Project: Report Manager

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 and 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. These must not be nested, i.e. IF ... THEN ... ELSE conditions must not be used within other IF ... THEN ... ELSE conditions.

The following operators can be used for comparisons:

• > greater than
• < less than
• >= greater than or equal to
• <= less than or equal to
• == equal to
• != not equal to

Data protection • Terms and Conditions • Cookies • Contact • Legal notes and Disclaimer