Creating user-defined output
- Select the query type.
- Specify the item filters.
-
In the output field table, right-click and select User Defined Output.
Certain user-defined functions such as product or company can be dragged from the filter and dropped on the output list.
- Specify a name for the function.
-
Select a formula from the selection box.
Text within a formula must be enclosed by quotation marks (" ").
- Click Test to test the syntax.
- Click Save.