Hi everyone,

Having difficulties with this formula. In a custom formula field. I need to check if the (dutch)bank account is valid. Basically I have to multiply each number in the account and than divide it by 11. If it is a round number it's good otherwise not! Bank_account__c is a text field, because it is also possible to have other chars in the number (different system).

IF (MOD(    ( VALUE(LEFT(TRIM(Bank_Account__c) , 1))* 9)

 + (  VALUE(RIGHT(LEFT(TRIM(Bank_Account__c) , 2),1)) * 8)

 + (  VALUE(RIGHT(LEFT(TRIM(Bank_Account__c) , 3),1)) * 7)

 + (  VALUE(RIGHT(LEFT(TRIM(Bank_Account__c) , 4),1)) * 6)

 + (  VALUE(RIGHT(LEFT(TRIM(Bank_Account__c) , 5),1))  * 5)

 + (  VALUE(RIGHT(LEFT(TRIM(Bank_Account__c) , 6),1))  * 4)

 + (  VALUE(RIGHT(LEFT(TRIM(Bank_Account__c) , 7),1))  * 3)

 + (  VALUE(RIGHT(LEFT(TRIM(Bank_Account__c) , 8),1)) * 2)

 + (  VALUE(RIGHT(LEFT(TRIM(Bank_Account__c) , 9),1))  * 1)

 , 11) > 0, "WRONG" , "OK")

Problem is --> Error: Compiled formula is too big to execute.

I have tried a lot. But can't really get it smaller. If someone has a trick to extract all the individual numbers, than I am in buisiness :smileyhappy:

Hope to hear more.

Thanks

Jeroen