Functions
FunctionsNumericBase let you combine function calls in you formulas. You can either use the buildin functions, or create new ones yourself.
Some buildin functions let you perform various summary calculations on you data, such as summary, average, sorting, etc.
The function call syntax
A function call has two elements that must be in the following order:
 Function name. Must be a "simple name"  any combination of digits, letters, the underscore sign (_), and the tilde sign (~), that does not begin with a digit.
 Argument list  a sequence of zero or more formulas separated by commas, and surrounded by parentheses.
Function with zero augments
If the function has zero augments, then you can omit the argument list: for example func_name is equivalent to func_name().
Build in functions.
NumericBase comes with a some buildin functions. These functions perform the standard mathematical functions such as sinus, cosine, logarithm , etc. Other buildin functions perform operations that are unique to NumericBase.
The following table shows the functions that are unique to NumericBase.

Some of the buildin functions are demonstrated in the following screenshot:
Screenshot: some of the buildin functions
Implicit range
Some functions, such as row and prev, can not be calculated at the base row. When you use these functions at the base row, as in the above screenshot, the functions evaluate to a (range) message. This is called an implicit range because, like in range formulas, it produces different values across the rows of the table.
Copyright © 2003  2024 by symbol click. Contact info
Where can be found a list of buildin functions?