CALCULATIONS AND FORMULAS
The following is a list of functions that can be used within calculation and formula expressions:
| Function |
Value
Returned |
Example |
|||
| ABS(value) | The absolute (unsigned) 'value' | @ABS(-25.9) returns 25.9 ; @ABS(12.45) return 12.45 | |||
|
|
|
|||
| Cos(a) |
The Trigonometric Cosine of a |
@Cos(60) returns 0.5 |
|||
| IF(exp,then,else) | If 'exp' != 0 return value of 'then' else return value of 'else' | @IF({IJC}<250000,1.5,1.25) | |||
| INT(a) |
The Integer of a |
@INT(2.99) returns 2 |
|||
| MAX(a,b) |
The maximum of a and b |
@MAX(12,-1) returns 12 |
|||
| MIN(a,b) |
The minimum of a and b | @MIN(12,-1) returns -1 |
|||
| PARENT(columnname) |
The value in column 'columnname' of
the 'parent' worksheet |
@PARENT(QTY) will return the value in
the QTY column in the parent worksheet (actually equivalent to {Q}) |
|||
| PROJECTTOTAL() |
The current Project Total |
* Do not use this where it will
change the Project Cost as each time the Function is evaluated, it will change the Project Cost and therefore become cyclical |
|||
| ROUND(a,p) |
The rounded value of a using
precision p |
@ROUND(2.344,2) returns 2.34 |
|||
| RCCOST(RC,qty) | The rate of resource 'RC' * the quantity 'qty' | @RC(CONC32,{Q}*1.2wste) | |||
| ROUNDUP(a,p) |
The rounded up value of a using
precision p |
@ROUNDUP(2.344,2) returns 2.35 |
|||
| Sin(a) |
The Trigonometric Sine of a |
@Sin(30) returns 0.5 |
|||
| Tan(a) |
The Trigonometric Tangent of a |
@Tan(45) return 1 |
|||
| SUBTOTAL(columnname) |
The subtotal of the 'columnname'
column on this row |
@SUBTOTAL(COST) will return the
subtotal in the 'COST' column on this row * NOTE: The value is not affected by 'Subtotal Flags' |
|||
| MANHOURS() | The number of Mhr(s) or Hr(s) of all cost items on this row that
has a Cost Category starting with 'LA". NOTE: All child Worksheets MUST have a 'MHRS' column |
@MANHOURS() | |||