+ Start a Discussion
Mario OrozcoMario Orozco 

Help on a formula field please.

I'm not familiar using formulas in salesforce.
First I have the following Checkbox type fields:
- High constitutive
- RFC
- Powers
- Proof of addresses 

And then I have to create a formula field called "Completed File" that indicates the percentage that is equivalent to the marked checks. Please anyone ho have more knowledge on this can help me ?

Thanks a lot!
AnkaiahAnkaiah (Salesforce Developers) 
Hi Mario,
Try with below formula
(If( High_constitutive__c, 1, 0)+ If( Powers__c , 1, 0)+ If( Proof_of_addresses__c , 1, 0) + If( RFC__c , 1, 0))/4

If this helps, please mark it as best answer

Thanks!!
Debaranjan GhoshDebaranjan Ghosh
Hello Ankaiah,

The formula looks ok only with a slight Modification by multipleying it with 100 to get the % as mentioned by Mario ie 
((If( High_constitutive__c, 1, 0)+ If( Powers__c , 1, 0)+ If( Proof_of_addresses__c , 1, 0) + If( RFC__c , 1, 0))/4)*100

Thanks 
Debaranjan Ghosh
 
AnkaiahAnkaiah (Salesforce Developers) 
Hi Debaranjan,

Here formula return type is percentage. There is no need to multiply with 100.

Thanks!!