Alteryx Designer Desktop Discussions

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

Counting Number Range

Jenina
8 - Asteroid

Dear Community,

 

Is there a way to count the number range from a column. Similar function to number filters in excel.

Please see attached sample, the color matches the output.

Thank you!

 

 

 

5 REPLIES 5
binuacs
21 - Polaris

@Jenina a batch macro should work on your use-case

image.png

Jenina
8 - Asteroid

@binuacs  It works! Thanks as always 

Jenina
8 - Asteroid

@binuacs  Hello! I ran the workflow today and saw an amount more than 5mm, but it doesn't reflect on the output. I saw the formula was already in ABS so not sure why.

File attached.

 

Thanks!

binuacs
21 - Polaris

@Jenina There was a space in the flag6 name which was causing the issue, updated workflow attached

image.png

Jenina
8 - Asteroid

@binuacs  Got it, thank you!

Polls
We’re dying to get your help in determining what the new profile picture frame should be this Halloween. Cast your vote and help us haunt the Community with the best spooky character.
Don’t ghost us—pick your favorite now!
Labels