community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Formula that will only grab numbers divisible by a certain number

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   

 

Alteryx Certified Partner
Alteryx Certified Partner
Mod(number,99)=0
Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Quasar

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

workflow.PNGWorkflow

Labels