Auto-Populate Amount in Potentials
Hello,
What I'm trying to do seems really complicated and if it's even possible, it'll probably have to be done using a custom function. My primary goal is to get an accurate amount input in the expected revenue field. I'm trying to do this by having an amount auto-populate in the "Amount" field in a Potential. The amount is not just a set amount, it's dependent on several variables.
I have a custom currency field (called Average Production) that will have an amount manually populated in it, I'll also have a check box field that will be manually controlled. If the check box is checked I need the Amount from my Average Production field multiplied by .029 (2.9%) with the result populated into the amount field. If the box is unchecked and the Average Production is higher than $50,000 I need it multiplied by .034 and if it's lower than $50,000 I need it multiplied by .037 with the result populated into the amount field. Is there any way to accomplish this?