In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Count length of numbers

SH_94
11 - Bolide

Dear community,

 

I would like to count how many number for the numbers listed below. May i know what formula i can use in this case?

Data

1. 292839383

2.847475

3.48484

 

Result

1. 9

2. 6

3. 5

 

 

3 REPLIES 3
atcodedog05
22 - Nova
22 - Nova

Hi @SH_94 

 

Use formula

 

 

Length(ToString([Field1]))

 

 

Hope this helps : )

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @SH_94 

Cheers and have a nice day!

jay_char
8 - Asteroid

👍

Labels
Top Solution Authors