You need to sign in to do that
Don't have an account?
Mario 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!
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!
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!!
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
Here formula return type is percentage. There is no need to multiply with 100.
Thanks!!