+ Start a Discussion
lil_rangerlil_ranger 

Help with percentage formula field

I have 3 survey questions that are ranked 1-5.  I'm trying to create a percentage formula field that will give me the overall percentage of the 3 questions.  

 

survey_question1__c = 4

survey_question2__c = 5

survey_question3__c = 5

 

Any help would be greatly appreciated.

Best Answer chosen by Admin (Salesforce Developers) 
phiberoptikphiberoptik

Can you give me an example of what you mean by the percentage of the three? So for your example below, would the math be: (4+5+5)/15? If so:

 

((survey_question1__c + survey_question2__c + survey_question3__c ) / 15) * 100

 

 

All Answers

phiberoptikphiberoptik

Can you give me an example of what you mean by the percentage of the three? So for your example below, would the math be: (4+5+5)/15? If so:

 

((survey_question1__c + survey_question2__c + survey_question3__c ) / 15) * 100

 

 

This was selected as the best answer
lil_rangerlil_ranger

That was simple enough.  Thank you!

ssrssr

Hi,

 

I need comma after thousands,

 

f0r example i enterd 50000 it wil take 500,00 like that

 

could you plese help me do you have any solutions

phiberoptikphiberoptik

Hi ssr, what does your question have to do with the topic you added your reply to?

 

The original poster is asking about a percentage formula, which does not involve commas. Please post your question in the forum as its own question. Make sure to add more detail around what you are doing.