Help Home
 PDF Version
 Welcome
    Ask Questions!
    How To Order
    What is a PDF Manual?
    How to Get Support?
    End-User License Agreement
 Installation
    System Requirements
    Installing from Internet
    Enter the Activation Key
    Upgrades
    Terminal Server
 Getting Started
    What is a Custom Table?
    What is a Custom View?
    Your First Custom Table
    Your First Custom View
 ACT! Interface
    Rename ACT! Views
    Email Template Button
    Phone Dialer History
    Send Text Message
    Navigation Bar
 Customize Columns
    Best Fit All
    Scroll Bars
    Customize
    Column Sets
    Column Style
    Drag and Drop
    Freeze or Lock
    Math Functions
    Totals on last row
    Appearance
 Queries and Finding
    Intelli-Find
    Query Builder
    Query Manager
    Filter Row
    Date Range
 Toolbar and Menus
    Column Popup Menu
    List Popup Menu
    Main Toolbar
 Toolkit  Designer
    About The Designer
    Designer Custom Forms
    Designing Sub Tables
    Controls - Lists
    Controls - Tab Pages
    Controls - Auto-Increment Field
    Controls - Unique Number
 Tables - Custom
    Adding a Custom Table
    Removing a Custom Table
    Adding or Removing Fields 
    Changing The Table Icon
 Tables - Templates
    Importing Tables
    Exporting Tables
    Move To Another DB
 Math Functions
    Between Contact Fields
    Between Custom Table Fields
    Summing Up Parent Table
    Summing Up Child Tables
    Summing Between Tables
    Column Totals
    Formula Builder Window
    Conditional Statement
 General Features
    Sorting the List
    Grouping like rows
    Visual Style
    Color - Single Row
    Color - Columns
    Color - Rules
    Style - Card
    Style - Row
 Printing Reports
    Print Preview
 Document Templates
    Creating Templates
    Word Templates
    ACT Templates
 Documents and Emails
    Email Templates
    Creating Emails
    Creating Documents

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:

  1. Select the field from the field list and click ADD FIELD
  2. Enter your math function symbol like a plus sign "+"
  3. Select the next desired field from the field list and click ADD FIELD
  4. 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