You can add a formula directly within a search. Some common reasons for using a formula in a search are to perform mathematical functions, check for and replace null values, or add if...then...else logic.

To create a formula in a search:

- Start a new search, or choose an existing answer.
- If the answer shows a chart, switch to Data View.
Switch to Data View

- Click the formula icon in the upper right hand side of the table.
Create a new formula in an answer

- Type your formula in the Formula Builder.
Use the Formula Builder

- You can see a list of formula operators with examples by clicking on Formula Assistant.
Examples in the Formula Assistant

- If you want to change what your formula returns, use the Advanced settings.
Depending on your formula, you may be able to change:

- Data type
- ATTRIBUTE or MEASURE
- Aggregation type

Advanced settings in the Formula Builder

- Name the formlua by clicking on its title and typing the new name. Click Save.