ShowAll Questionssorted byDate Posted
Eric Boller 14

# Formula Field to Calculate Percentage

I'm trying to write a formula field that determines percent of other fields completed but getting thousands of percents. Why doesn't the below work?

(IF(ISBLANK( TEXT(Industry__c)   ), 0, 1) + IF(ISBLANK( No_of_Employees__c ),
0,1) + IF(ISBLANK(  Number_of_Locations__c  ), 0,1) + IF(ISBLANK(   Cities_of_Locations__c   ), 0,1) + IF(ISBLANK(   TEXT(Current_Carrier__c)   ), 0,1) + IF(ISBLANK(   Factors__c   ), 0,1) + IF(ISBLANK(   Pain__c   ), 0,1) + IF( Number_of_Locations__c  = 1, 0,1)) * 12.5
Arunkumar R
Hi Eric,

Could you try any one of the below approach?

```((IF(ISBLANK( TEXT(Industry__c)   ), 0, 1) + IF(ISBLANK( No_of_Employees__c ),
0,1) + IF(ISBLANK(  Number_of_Locations__c  ), 0,1) + IF(ISBLANK(   Cities_of_Locations__c   ), 0,1) + IF(ISBLANK(   TEXT(Current_Carrier__c)   ), 0,1) + IF(ISBLANK(   Factors__c   ), 0,1) + IF(ISBLANK(   Pain__c   ), 0,1) + IF( Number_of_Locations__c  = 1, 0,1)) * 12.5) / 100```
OR
```(IF(ISBLANK( TEXT(Industry__c)   ), 0, 1) + IF(ISBLANK( No_of_Employees__c ),
0,1) + IF(ISBLANK(  Number_of_Locations__c  ), 0,1) + IF(ISBLANK(   Cities_of_Locations__c   ), 0,1) + IF(ISBLANK(   TEXT(Current_Carrier__c)   ), 0,1) + IF(ISBLANK(   Factors__c   ), 0,1) + IF(ISBLANK(   Pain__c   ), 0,1) + IF( Number_of_Locations__c  = 1, 0,1)) * 0.125```
Eric Boller 14
That seems to have worked for the percentage, but the percentage doesn't update when the integer fields are populated. Why would that be?
Swarna Chinthalachervu Venkata 4
20