Phorum: speed & power.

Add-ons for Sage ACT! CRM

ACT! addons by : Abacus Calculated Fields, PicturePlus, Quick Navigation List, Employment History, Quick Search, Presentation for ACT!
Are you sure you want to report this post?

Re: How to calculate an average

Posted by: Matthew

Date: 05/03/2007 01:16PM

To average four numbers you will need to have an extra fifth field set up to allow you to paste the average into it. So first go to define fields and add a fifth field called "Average"
Now in ABACUS go to the field Average and click on edit formula. Enter the following ([field1]+[field2]+[field3]+[field4])/4 - that's it!


You may optionally give an explanation for why this post was reported, which will be sent to the moderators along with the report. This can help the moderator to understand why you reported the post.

ACT! software CRM addons - best plugins for ACT contact management software ( Act! by Sage software : ACT!2005, ACT!2006, ACT!2007, ACT!2008, Act by Sage Premium for Workgroups ).
Custom addon solutions ( ACT! add ons ) development and CRM (Customer Relationship Management) software training and consulting.