Community
Showing results for 
Search instead for 
Do you mean 
Reply

Need Help Calculating results using a calculated result

Bronze Contributor
Posts: 1,416
Country: USA

Need Help Calculating results using a calculated result

I would like to build the following Fields in an ACT opportunity screen:

 

Black = data entered into a field

Red = calculated field

 

Cost per unit   $ amount entered

Markup            Decimal amount entered such as .30

Sales price      Cost per unit / (1-markup)

Shop supplies  Sales price * .0375

Net profit          Sales Price -(less cost per unit) - (less shop supplies)

 

It appears that we cannot use a calculated field to calculate a new field.

It also appears that the operands can not be used more than once in a formulae, even if separated by parenthesis.  

 

Can this be done with the program as it is or am I not thinking this through clearly?

 

Many thanks for your help.

John Purdy
ACT! Premium 2016 (V. 18)
ASUS Transformerwith 4GB, Win 10 Pro, & Office 365, 32bit
Administrator
Posts: 682
Country: United_Kingdom

Re: Need Help Calculating results using a calculated result

Hi jnpurdy, you're right about some of the limitations here, you cant use the result of a calculated field as the input for another - and there are limitations on the number of times operators can be used.

The first calculated fields can be created just fine, and the second works too if you just duplicate the logic of the first and add the "* .0375 ".

However that last calculated field will contain to many different operators, so likely won't be possible in the base version of Act! without addins.
Bronze Contributor
Posts: 1,416
Country: USA

Re: Need Help Calculating results using a calculated result

thanks for the answer.

 

BTW, do you know of any 3rd party program that will make these calculations possible?

John Purdy
ACT! Premium 2016 (V. 18)
ASUS Transformerwith 4GB, Win 10 Pro, & Office 365, 32bit
Nickel Elite Contributor
Posts: 957
Country: USA

Re: Need Help Calculating results using a calculated result

Automatic Field Calculations addon

http://exponenciel.com/actaddons.aspx?Ver=19  

Bill Williams - Owner / ACT! Consultant / Trainer at Fill Staff "ACT! FOR RECRUITERS"
Manage Your ACT! Backups http://fillstaff.com/backupfolderspro.html - FREE
BIG ACT! LAYOUTS for Larger Monitors www.bigactlayouts.com
Download Free BullZip PDF Printer and Print directly to PDF http://www.bullzip.com/products/pdf/info.php