HelpConsole 2008 SP3.4 - DurkinToolkit


	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 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 Query Builder Filter Row Date Range Find Panel 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 - Incremental Number Tables - Custom Adding a Custom Table Removing a Custom Table Adding or Removing Fields 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 Grouping like rows Color - Columns Color - Rules Printing Reports Print Preview Document Templates Creating Templates Word Templates ACT Templates Documents and Emails Email Templates Creating Emails

Home > Math Functions > Summing Between Tables

Summing Between Tables

You can create math formulas that use fields from different tables. These tables can be ACT!'s native tables like Contacts, Companies or groups. These tables could also be different Custom tables you have created. On the screen shot below we calculate the Automobile.Commission field based on the Contact.Commission field in the Contact Table and the Automobile.Price field in the custom table.

To create a math function using multiple tables follow these steps:

Go to the Custom Form where the results will be placed.
Click on the DESIGNER button on the lower left corner.
In the Toolkit Designer click on the MATH FUNCTIONS icon on the toolbar.
Now at the bottom of the window in the Math Function panel click 'NEW'
Enter a name and the results field.
Click on Builder window to enter the formula expression.

Remember you can select fields from different tables when building your expression.
Please see Formula Builder Window for more details regarding your math expression.