| | Using functions in formulas (SQL) |
| Resolution | Using functions in formulasWhen you insert a function into a formula, the abbreviation of that function appears in the formula text area. Parentheses after the abbreviation mean that you need to provide one or more values for calculating the function. A separator (shown as a comma in the Help Topics) appears between multiple values. Depending on the function, these values can be numbers, constants, variables, formulas, or other functions. For details check out, Sage Estimating Help. Function | Syntax | Function | Syntax | absolute value | ABS (value) | maximum | MAX (value1, value2, value3, . . .) | arc cosine | ACOS (value) | minimum | MIN (value1, value2, value3, . . .) | arc sine | ASIN (value) | modulus | MOD (value, divisor) | arc tangent | ATAN (value) | power | POWER (value, power) | average | AVG (value1, value2, value3, . . .) | quantity | QUANTITY | cosine | COS (angle) | round | ROUND (value, digit) | duration | DURATION | round to nearest | ROUNDTO (value, method, multiplier) Where the method is: -1 round down
0 round to closest
1 round up | hyperbolic cosine | COSH (value) | sine | SIN (angle) | hyperbolic sine | SINH (value) | square root | SQRT (value) | hyperbolic tangent | TANH (value) | summation | SUM (value1, value2, value3, . . .) | if/then logic | IF (condition, true, false) | tangent | TAN (angle) | job size | JOBSIZE | truncate | TRUNC (value, digit) |
[BCB:164:Chat Estimating US:ECB]
|
|