community Alteryx IO Alteryx.com
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Formula that will only grab numbers divisible by a certain number

garretwalters12
8 - Asteroid
‎11-13-2018 08:38 AM

I have a list of numbers but I only need the ones divisible by 99

 

EX Of Data                                Outcome Needed

99                                                              99

198                                                            198

25

10

8   

 

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
MarqueeCrew
20 - Arcturus
20 - Arcturus
‎11-13-2018 08:41 AM
Mod(number,99)=0
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Reply
ponraj
13 - Pulsar
‎11-13-2018 09:09 AM

I am uploading sample workflow for your case with the formula shared by @MarqueeCrew

WorkflowWorkflow

Formula that will only grab numbers divisible by a certain number.yxmd
Reply
0 Likes
learn more about the python upgrade coming in may 2024
Labels