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
20 - Arcturus

@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
20 - Arcturus

@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!

Labels