• Larz78
  • NEWBIE
  • 0 Points
  • Member since 2010

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 0
    Replies

Hello,

i am a newbie with SF and i am in desperate need to create a custom numeric field with inside a formula with the following validation rule:

 

1)take the first 9 number provided and multiply these numbers repectly with:6, 5, 7, 2, 3, 4, 5, 6, 7

  for example if the 9 numbers are: 1,2,3,4,5,6,7,8,9 it is: (1*6) + (2*5) + (3*7) and so on....

 

2)Sum of the multiplications

 

3)Check of the last number provided (the 10th number) with the following: check digit = sum of the multiplications -  (218/11) * 11

 

Thanks a lot very much.