...
| Note |
|---|
The Formula Builder can store up to 5000 characters. If you build a larger query outside of Datameer then paste the query in, the builder accept accepts it. However, if you edit the query, the builder only displays the first 5000 characters. |
| Anchor | ||||
|---|---|---|---|---|
|
As of Datameer 7.2
- Access the formula builder by opening a workbook, click within the column you would like build a formula, and open the Fx tab in the workbook inspector.
- Select a category from the column on the left and select a function from the list on the right.
- Read the description for the selected function at the bottom of the Formula Builder. Click Online Documentation and Samples for additional information.
- Enter the arguments as shown in the Formula Builder. To do so, type the column that contains the desired data. The types of arguments required are displayed next to the arguments' names. You can also enter a null argument by typing in null, all lower case.
- If the function supports multiple elements for a single argument, a + (plus) button is available. Click to add additional elements.
- Click Add to Formula to finish entering the formula. The results are shown in the column selected from step one.
...