Newbies Cubidoo Posted April 20, 2010 Newbies Posted April 20, 2010 I am trying to achieve the following. I have a field called Number. In this field there can be any positive integer. If the integer consists of 2 or more digits then I need to split them and sum them. This I need to repeat until I have a single digit number. For example: Number = 37 Result should be 3 + 7 = 11 -> 1 + 1 = 2 (final result) or Number 134 Result 1 + 3 + 4= 8 (final result) Which functions can I use to split numbers? Which function can I use to repeat this process until I have a single digit?
Newbies Cubidoo Posted April 20, 2010 Author Newbies Posted April 20, 2010 Thank you that link gave the solution
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now