Briefly |
This program has many built-in functions to use in your own formulas. This section describes them and what they all mean. |
To use a built-in function in the formula editor, double-click on its name in the function list. Or, type its name and an open parenthesis "(". That parenthesis creates a close-parenthesis. If you don't type the parenthesis (and put the function's argument inside) the formula will not work.
Don't forget the parentheses!
Follow the links below to a list of the built-in functions this program supports as of September 1999:
Categories of Functions
Here are the eight different categories of functions listed in the function list.
Arithmetic such as floor( ) and modulo( ).
Conditional such as if( ) and switch( ).
Distribution such as normalDensity(x).
Logical such as isNumber( ). These always return either true or false.
Random Number such as randomNormal( ).
Statistical
One Attribute such as mean( ) and uniqueValues( ).
Two Attributes such as correlation( ).
Transformations such as prev( ) and runLength( )
String such as concat( ).
Trigonometric such as cos( ).
Functions are either aggregate or case functions. The One Attribute and Two Attribute statistical functions above are aggregates; the rest are case.
Special Values in the formula editor
Uses of formulas:
Writing formulas for attributes