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
 Settings
    Options
       About Tab
       General Tab
       Toolkit Projects Tab
    Appearances
 Toolbar
 Right Click Menu
 Color - Rules
 Documents
    Document Templates
       Creating Templates
       Word Templates
       ACT Templates
    Documents and Emails
       Email Templates
       Creating Emails
       Creating Documents
 Project Management
    Tables - Custom
       Adding a Custom Table
       Removing a Custom Table
       Adding or Removing Fields 
       Changing The Table Icon
    Getting Started
       What is a Custom Table?
       What is a Custom View?
       Your First Custom Table
       Your First Custom View
    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
    Toolkit  Designer
       About The Designer
       Designer Custom Forms
       Designing Sub Tables
       Controls - Lists
       Controls - Tab Pages
       Controls - Auto-Increment Field
       Controls - Unique Number
    ACT! Interface
       Rename ACT! Views
       Email Template Button
       Phone Dialer History
       Send Text Message
       Navigation Bar
    Queries and Finding
       Intelli-Find
       Query Builder
       Query Manager
       Filter Row
       Date Range
    Toolbar and Menus
       Column Popup Menu
       List Popup Menu
       Main Toolbar
    Tables - Templates
       Importing Tables
       Exporting Tables
       Move To Another DB
    General Features
       Sorting the List
       Grouping like rows
       Visual Style
       Color - Single Row
       Color - Columns
       Style - Row
    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
    Printing Reports
       Print Preview

Home > Project Management > Math Functions

Math Functions

The Durkin Toolkit for ACT! has some very powerful math functions built into the user interface.

These math functions cover:

  • simple field-to-field calculations
  • summing up to the parent
  • more complex child-field to parent field formulas.

 



This screen show an example of Summing Up Child Tables 


There are two ways of creating formulas between tables.

  • The first involves calculating the child table's values in a column e.g. totalling above to $5950  then taking that total and copying it into the parent record. We call this Summing Up see below.
  • The second method is using one or more fields from the parent table in a formula between fields in the child table like when calculating the commision for each sub-item like invoices or discounts.

See also