Community
Showing results for 
Search instead for 
Do you mean 
Reply

NEED HELP PLEASE!!

New Member
Posts: 2
Country:

NEED HELP PLEASE!!

Upgraded ACT database to Act 2011 and Word 2000 to Word 2010- all Word mail merge documents didn't translate properly so learned to manually rebuilt fields but formula calculations won't work- working in a table, need to use fields to bring $$$ value of (ACT field-cost )minus (ACTfield -agency fee) to get subtotal then calculate 13% of subtotal for GST and add Subtotal and GST for total. HELP!!! 

Platinum Elite Contributor
Posts: 6,537
Country: USA

Re: NEED HELP PLEASE!!

Hello shepneedshelp,
Welcome to the Sage ACT! Community. Where are the formulas? Where did you create them?

Greig Hollister

Note: Effective 6/1/13, Sage no longers provides support for the Act! software. This is now provided by Swiftpage.

New Member
Posts: 2
Country:

Re: NEED HELP PLEASE!!

The formulas were created in a Word 2000 table. B6 is Act field- Ad Cost and the next one below B7 is Act field-Agency Fee. both are dollar amounts B8 should be a subtotal of B6 minus B7 (B7 will often be $0.00) and then B9 (taxes) should be 13% of subtotal to get B10 Total. Above these are B1 -B5- insertion dates, ad type etc all ACT fields.