Back to Items IndexItem - Math Formula
Please refer to Adding a New Item for specific information on how to add an ITEM and how to change its properties.
Description
Is used for calculations.
Properties
| Class Name | A unique name for this item. The class name is display only and cannot be changed. |
| Name | Enter a meaningful name for this Item so that you, and other people, will easily recognize what it is for. |
| Enabled | No - The ITEM is not enabled and will not update
when its TASK updates Yes - The ITEM is enabled and will update when its TASK updates. |
| Math Formula | To refer to the value of another ITEM, enclose
the number of the ITEM in square brackets. For example ITEM 6 from TASK 1 would be [1-6]. The following table lists the operations available as math expressions. "+" Addition: Example a) 2 + 2 Example b) [1-1] + 2 Example c) [1-1] + [1-2] "-" Subtraction Example a) 4 - 2 Example b) [1-1] - 2 Example c) [1-1] - [1-2] "^" Exponentiation Example a) 2 ^ 2 Example b) [1-1] ^ 2 Example c) [1-1] ^ [1-2] "*" Multiplication Example a) 2 * 2 Example b) [1-1] * 2 Example c) [1-1] * [1-2] "/" Division Example a) 2 / 2 Example b) [1-1] / 2 Example c) [1-1] / [1-2] "& " Logical And Example a) 2 & 2 Example b) [1-1] & 2 Example c) [1-1] & [1-2] "|" Logical Or Example a) 2 | 2 Example b) [1-1] | 2 Example c) [1-1] | [1-2]
The following table lists the functions available as mathematical expressions. Function Description ABS(B) The absolute value is returned. ADD(A, B) Adds the two elements. IF(A,B,C) If A is nonzero then B is returned. If A is zero then C is returned. A can contain one of the relational operators: greater than (>), less than (<), equal to (=), or not equal to (!). MAX(A,B, . . .) Returns the maximum value of all arguments. Accepts a variable number of arguments, up to a maximum of 30 arguments. MIN(A, B, . . .) Returns the minimum value of all arguments. Accepts a variable number of arguments, up to a maximum of 30 arguments. NEG(B) Changes the sign of the value. For example, NEG (15) = -15. NOT(B) If B is zero then a 1 is returned. If B is not zero then a zero is returned. ROUNDUP(B,D) Rounds the value up to the next whole number, using the specified number of decimal places (D). A zero can be used for no decimal places. Negative precision specifies tenths, hundredths, etc. ROUND(B,D) Rounds the value to the nearest whole number, using the specified number of decimal places (D). A zero can be used for no decimal places. Negative precision specifies tenths, hundredths, etc. SUM(B,C, . . .) Sums the arguments. Accepts a variable number of arguments, up to a maximum of 30 arguments. TRUNCATE(B,D) Rounds the value down to the next whole number, using the specified number of decimal places (D). A zero can be used for no decimal places. Negative precision specifies tenths, hundredths, etc. |