+ Start a Discussion
vikramkkvikramkk 

Formula exceeding character limit

Hi

 

I am using following formula for a custom field. But it is exceeding character limit. Any help would be greatly appreciated.

 

IF(

AND(

 CO_of_Inverters_2__c  > 0 , NOT( ISBLANK( TEXT( CO_Inverter_Model_2__c  ) ) ) ,NOT( ISBLANK( TEXT( CO_Inverter_Model_3__c  ) ) )

),  

TEXT( CO_of_Inverters__c  ) &" "& TEXT(  CO_Inverter_Model__c  ) &" & " &TEXT( CO_of_Inverters_2__c ) &" "& TEXT( CO_Inverter_Model_2__c )&" & " &TEXT( CO_of_Inverters_3__c ) &" "& TEXT( CO_Inverter_Model_3__c ) &" inverters" ,  

IF(

AND(

 CO_of_Inverters_2__c  > 0 , NOT( ISBLANK( TEXT( CO_Inverter_Model_2__c  ) ) )

),

TEXT( CO_of_Inverters__c  ) &" "& TEXT(  CO_Inverter_Model__c  ) &" & " &TEXT( CO_of_Inverters_2__c ) &" "& TEXT( CO_Inverter_Model_2__c ) &" inverters",

TEXT( CO_of_Inverters__c  )&" "& TEXT( CO_Inverter_Model__c ) &" inverters"

)

)

saraha@groupesci.comsaraha@groupesci.com

Are the fields you are referring to also formula fields? If so, all the formulas contribute to the total limit. Ideally, you can find a way to reduce the number of times you are referring to formula fields. If not, you may need to do your calculations in a trigger.

 

--Sarah