You can create a formula in a worksheet by using the Formula Builder. When you do
this, the result of the formula gets added to the worksheet as a column.
Use these steps to create a formula:

Create a new worksheet, or edit an existing
one.

Click the + button next to
Formulas.
Figure: Create a new formula in a worksheet

Type your formula in the Formula Builder.
Figure: Use the Formula Builder
Note: Formulas elements are color coded by type and can include the formula
operators and functions? (blue), the names of columns (purple)?, and/or
constants? (black).
 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
Figure: Advanced settings in the Formula Builder
 You can see a list of formula operators with examples by clicking on Formula Assistant.
Figure: Examples in the Formula Assistant

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