+ Start a Discussion
RobKretzRobKretz 

Rule/Formula- GP% based on $$ Amount??

Within our "Opportunity" layout we have several fields

1. Amount ( projected annual rev; default)

2. Estimated Gross Profit %

3. Gross Profit

 

For example-

 

Our Sales agent is working on an opportunity for company XYZ. We know that..

1. Amount = $255,933

2. Estimated Gross Profit % = 35%

3. Gross Profit= ?

 

Is there a formula or validation rule that allows the Gross Profit # to generate based off the Amount and GP % 

 

Thank you in advance. 

 

-Rob Kretzmer

EnthEnth

If you want this populated in the Gross Profit field you'll need a worfklow, if you want to replace your Gross Profit with a Currency Formula field you can do it that way instead and guarantee the calculation is always up to date and correct.

 

Your formula wll be as simple as:  

 

amount__c * est_gross_profit_pcnt__c 

 

Use the formula builder to pick your fieldnames to replace the above. If you decide to use a workflow the logic is the same for a Field Update. (I've assumed your pcnt field is of percent type).

RobKretzRobKretz

Thanks for your reply. 

 

I've created a Field Update with the following: 

 

Object: Opportunity 

Field to Update:

Opportunity: Gross Profit

Field Data Type: Currency 

Formula: Amount*Estimated_GP__c

 

 

(Note: Estimated GP is a percent data type)  

 

 

I've gone through different opportunities to see if it works but  the Gross Profit field is not populating a number. 

 

what am I missing? 

 

Thanks in advance!