The function library contains the User Defined Functions. These functions act like any other Excel or Exsion function and will be available for all Excel documents. This library can be shared among all Exsion users.
Activating this function will show the following screen that will be empty at first time use:
Click “New” to create a new function or “Edit” to modify an existing one.
| Field | Description |
|---|---|
| Table | The name of the table that will be accessed by this function. |
| Field | The name of the field from which information will be retrieved. |
| Method | The calculation method for that field (Sum, Average, Count, Minimum or Maximum). |
| Index | The name of the index to use. This will be an argument to the function. |
| Name | Name of this function. |
| Description | A brief description for this function. This will be shown by Excel’s function wizard. |
| Display | Show table/field name or number. |
| Connection-ID | The number of the connection to use. |
Click the “>>” button to show the function arguments. The information displayed here depends on the chosen index.
| Field | Description |
|---|---|
| Name | If the field name is not very clear a different name can be entered here. This will be used by Excel’s function wizard. |
| Description | A brief description for this argument. This will be used by Excel’s function wizard. |
| Filter (fixed) | This can be used to enter a fixed filter. If this is not blank, this argument will not be shown in Excel’s function wizard. |
| Hide | When checked, the argument will be hidden even if no fixed filter is used. |
Click the “OK” button to store the function in the function library.
The function will now be available in Excel’s function wizard under the heading “Exsion library”.
