ActPresentation.com HOME FAQ FORUM info@ActPresentation.com
Phorum: speed & power.

ActPresentation.com


Add-ons for Sage ACT! CRM

ACT! addons by ActPresentation.com : Abacus Calculated Fields, PicturePlus, Quick Navigation List, Employment History, Quick Search, Presentation for ACT!

How to calculate percentage ?

Posted by: Donna

Date: March 04, 2013 06:31AM

I'd like very much to use the Abacus add-on with ACT!2011.
Addition and subtraction work fine, but I'm having trouble with this very basic calculation.

Field 1 = 4
Field 2 = 3
Field 3 = [Field 1] / [Field 2]

All three are number fields with 4 places to the left and 4 places to the right of the decimal.

I would like Field 3 to return "75%", but ".75" is acceptable.

Re: How to calculate percentage ?

Posted by: Admin

Date: March 04, 2013 06:33AM

the formula is very simple :

CONVERT( DECIMAL(10,2), [Field1]/ [Field2] )

Re: How to calculate percentage ?

Posted by: Donna

Date: March 04, 2013 06:35AM

Is it possible to show 75% instead of 0.75?

Re: How to calculate percentage ?

Posted by: Admin

Date: March 04, 2013 06:37AM

Yes it is possible to show 75% ... the formula would be:

ToStr( 100*[Field1]/ [Field2] ) + "%"

The target field (where you want to see 75%) should be character field ( not number field ) because number fields can't hold "%" symbol.

Re: How to calculate percentage ?

Posted by: Donna

Date: March 04, 2013 06:39AM

Thank you! I'll need to include this field in summary reports, so I'll need to keep it a number. I really appreciate your help!

Admin Wrote:
-------------------------------------------------------
> The target field (where you want to see 75%)
> should be character field ( not number field )
> because number fields can't hold "%" symbol.

Re: How to calculate percentage ?

Posted by: Admin

Date: March 04, 2013 06:41AM

One more option is to use the FORMAT function ( here is the link : [www.actpresentation.com] )

the formula would be : FORMAT( [Field1]/ [Field2], "%" )

PS. FORMAT function produces a string ( not number ) - which means target field should be Character

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.