Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
ShowAll Questionssorted byDate Posted
lil_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)
phiberoptik

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`

phiberoptik

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_ranger

That was simple enough.  Thank you!

ssr

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

phiberoptik

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.