A List of Formula Functions and Descriptions
This article provides a list of formula functions that can be used in formulas in DESTINI Estimator and Data Manager, including line item quantity formulas and assemblies.
| Function | Description |
|---|---|
| ABS( ) | Absolute value, which can be used as ABS(X) |
| ATAN( ) | ArcTangent function which can be used as ATAN(X) |
| CEIL( ) | CEIL(-3.2) = -3, CEIL(3.2) = 4 |
| COS( ) | Cosin function which can be used as COS(X), X is a real-type expression. COS returns the cosine of the angle X in radians. |
| COSH( ) | Cosinus Hyperbolic function which can be used as COSH(X) |
| COTAN( ) | CoTangent which can be used as COTAN(X) |
| DATEEQL | Tests if two dates are equal |
| DATEGT | Tests if the first date is greater than the second date |
| DATEGTE | Tests if the first date is greater than or equal to the second date |
| DATELT | Tests if the first date is less than the second date |
| DATELTE | Tests if the first date is less than or equal to the second date |
| EXP( ) | The constant E raised to the specified exponent which can be used as EXP(X) |
| FALSE | This is a mathematical constant = 0. |
| FLOOR( ) | FLOOR(-3.2) = -4, FLOOR(3.2) = 3 |
| IF( ) | If( condition, value if true, value if false) |
| INTPOW( ) | The INTPOW function raises Base to an integral power. INTPOW(2, 3) = 8. Note that result of INTPOW(2, 3.4) = 8 as well. |
| LN( ) | Natural log, which can be used as LN(X) |
| LOG( ) | Base 10 log, which can be used as LOG(X) |
| LOGN( ) | The LogN function returns the log base N of X. Example: LOGN(100, 10) = 2 |
| MAX( ) | MAX(2, 3) is 3. |
| MIN( ) | MIN(2, 3) is 2. |
| MOD( ) | Modulus computes the remainder after dividing its first operand by its second. MOD(5, 2) = 1. |
| POW( ) | The Power function raises Base to any power. For fractional exponents or exponents greater than MaxInt, Base must be greater than 0. |
| RND( ) | RND() function generates a random number (double value) between 0 and 1. |
| ROUND( ) | Round(value, numberDecimals) Rounds to the specified number of decimals. |
| SIGN( ) | SIGN(X) returns -1 if X<0; +1 if X>0, 0 if X=0; it can be used as SIGN(X) |
| SIN( ) | Sin function which can be used as SIN(X), X is a real-type expression. Sin returns the sine of the angle X in radians. |
| SINH( ) | Sin Hyperbolic function which can be used as SINH(X) |
| SQR( ) | Square function which can be used as SQR(X). |
| SQRT( ) | Square Root which can be used as SQRT(X) |
| SUM( ) | SUM(2,3,5,...) functions returns the sum of its arguments. There is no preset limit on the number of parameters. |
| TAN( ) | Tangent which can be used as TAN(X) |
| TextContains | TextContains( "Electrical Room", "Elec" ) = TRUE vs. TextContains( "Electrical Room", "Mech" ) = FALSE |
| TextEndsWith | TextEndsWith( "Electrical Room", "Elec" ) = FALSE vs. TextEndsWith( "Electrical Room", "Room" ) = TRUE |
| TextStartsWith | TextStartsWith( "Electrical Room", "Elec" ) = TRUE vs. TextStartsWith( "Electrical Room", "Room" ) = FALSE |
| TRUE | This is a mathematical constant = 1. |
| TRUNC( ) | Discards the fractional part of a number. e.g. TRUNC(-3.2) is -3, TRUNC(3.2) is 3. |
Note: The Dashboard and Project Views may not support all of these functions.