Math point has 27 operators and functions to allow a project to evaluate equations, drawing input from other points such as edit points or drop points.
Each Math point has a fixed expression associated with it that it will evaluate to produce a result. These expressions can include mathematical, conditional and logical operators, and functions.
Mathematical operators, in order of precedence:
Conditional operators, in order of precedence:
Logical operators, in order of precedence:
Functions take the form FN(x), where FN is the function name and x is an expression. Functions are:
Values from other points on the page (or indeed any other page in the project) can be used in the expression by including the ID name of the point. Note that referenced points must contain numeric data. Points that include non-numeric data will cause a reference error. Points that are blank (ie points that have not been filled in) will be treated as numeric zeros.
For example, an expression to add the values entered into two other points named A and B would simply be "A+B". While this is a simple case, more complex expressions can easily be constructed, involving fixed constants and brackets. For example, to take the average of three points named Alpha, Beta and Gamma: "(Alpha+Beta+Gamma)/3".
The conditional and logical operators are slightly different to the mathematical operators, as they will always result in a boolean result: true or false. A true result is represented by a 1, while a false result is represented by a 0. A conditional operator is true if the stated condition is met. For example, the condition 5 > 3 is true, and would evaluate to 1. The condition 4 != 4 on the other hand is false, and would evaluate to 0.
Logical combination operators are similar, except they convert both terms to Boolean, and then produce a Boolean result based on the relation between them: either an and relationship (both true), or an or relationship (one, the other, or both true).
On-screen, Math points appear identical to Edit points, but are read-only. The value will be computed automatically. Optionally they can be displayed inline, where the result box is to the right of the caption, saving space.
The data calculated and displayed in a Math point will be recorded in the data set like any other point, and is available for examination or use on the PC. It can also be used as an input to other Math points, Logic points or Layout points.
Math Points are not available in the Lite Edition.