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: JordanAustin

Date: 05/03/2007 04:56PM

I did as you said : ([field1]+[field2]+[field4)/3, what this did was just give me an odd series of numbers, say I input into field:1 5 and into field2: 5 and into field3: 5 the average number would be 5. However with the givin formula it gives me the number: 185. Do you know how to fix this?

Thanks for any help.

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.