Need Help Calculating results using a calculated result

[jnpurdy]

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.

[JonTaylor]

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.

[jnpurdy]

thanks for the answer.

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

[FILLSTAFF]

Automatic Field Calculations addon

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