Skip to main content
I need a formula that calculates the percentage that field 1 is of field 2. For instance: I have a number field that the sales rep will put a number in. I want to make a formula field that takes that number and calculates the percentage of the opp total field. (Field 1 has 2,700.00. Opp total is 4,500.00. since 2,700.00 is 60% of 4,500.00 then I want Salesforce to put 60% in the new field.
9 answers
  1. Eric Praud (Activ8 Solar Energies) Forum Ambassador
    Jan 8, 2021, 1:13 PM
    Even if the field has been renamed, its API name should still be Amount, not Total_Contract_or_Annual_Amount__c 

     

    Try:

     

    Rev_Share__c/Opportunity.Amount
0/9000