Home > Math Functions > Formula Builder Window
Formula Builder Window
The formula builder window allows you to select fields from ACT!'s native tables and any custom table you have created. To create a new formula follow these steps:
- Select the field from the field list and click ADD FIELD
- Enter your math function symbol like a plus sign "+"
- Select the next desired field from the field list and click ADD FIELD
- Click OK

Remember you can select fields from different tables when building your expression. In this example below we calculate the Commission field from the contacts multiplied by (x) the Price of the automobile. (See Summing Between Tables for more information on this example.)

Other mathmatical operations that can be done SUM() Scientific notation PI LOG SIN COSH RND() (random number)
See also
|