You need to sign in to do that
Don't have an account?
Sourav P
Complex formula Validation
Dear All,
Can anyone plz suggest , where i went wrong in creating the below formula, as per me formula is correct, and its working on some values, but not working on others. I couldn't ablle to identify where exactly i went wrong. thnx for your support.
Formula Creation Criteria :
The formula i created for this ,
Can anyone plz suggest , where i went wrong in creating the below formula, as per me formula is correct, and its working on some values, but not working on others. I couldn't ablle to identify where exactly i went wrong. thnx for your support.
Formula Creation Criteria :
The formula i created for this ,
AND( NOT(ISBLANK(Thai_Identification_Number__c)), VALUE(RIGHT(Thai_Identification_Number__c,1)) <> ( 11- ( IF( MOD( ROUND( ( VALUE(MID( Thai_Identification_Number__c ,1,1))*13 + VALUE(MID( Thai_Identification_Number__c ,2,1))*12 + VALUE(MID( Thai_Identification_Number__c ,3,1))*11 + VALUE(MID( Thai_Identification_Number__c ,4,1))*10 + VALUE(MID( Thai_Identification_Number__c ,5,1))*9 + VALUE(MID( Thai_Identification_Number__c ,6,1))*8 + VALUE(MID( Thai_Identification_Number__c ,7,1))*7 + VALUE(MID( Thai_Identification_Number__c ,8,1))*6 + VALUE(MID( Thai_Identification_Number__c ,9,1))*5 + VALUE(MID( Thai_Identification_Number__c ,10,1))*4 + VALUE(MID( Thai_Identification_Number__c ,11,1))*3 + VALUE(MID( Thai_Identification_Number__c ,12,1))*2 ) /11,1 )*10,10 )=0, 10, MOD( ROUND( ( VALUE(MID( Thai_Identification_Number__c ,1,1))*13 + VALUE(MID( Thai_Identification_Number__c ,2,1))*12 + VALUE(MID( Thai_Identification_Number__c ,3,1))*11 + VALUE(MID( Thai_Identification_Number__c ,4,1))*10 + VALUE(MID( Thai_Identification_Number__c ,5,1))*9 + VALUE(MID( Thai_Identification_Number__c ,6,1))*8 + VALUE(MID( Thai_Identification_Number__c ,7,1))*7 + VALUE(MID( Thai_Identification_Number__c ,8,1))*6 + VALUE(MID( Thai_Identification_Number__c ,9,1))*5 + VALUE(MID( Thai_Identification_Number__c ,10,1))*4 + VALUE(MID( Thai_Identification_Number__c ,11,1))*3 + VALUE(MID( Thai_Identification_Number__c ,12,1))*2 ) /11,1 )*10,10 ) ) ) ) )While its working for some values, I ont know why its not working for the value mentioned in my screenshot " 1488708326392"
there is nothing wrong with your formula based on "1488708326392".
the problem is not there...
you have to show the rest of the formual and provide the screenshot of Thai_Identification_Number__c-field.
your AND-formula will return false and I can't connect the formula's result to the Thai Identification Number.