Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×

This topic is 5389 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

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?

This topic is 5389 days old. Please don't post here. Open a new topic instead.

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.