01-21-2018 08:22 PM
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.
01-22-2018 01:48 AM
01-22-2018 05:37 AM
thanks for the answer.
BTW, do you know of any 3rd party program that will make these calculations possible?
01-26-2018 08:02 AM
Automatic Field Calculations addon