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

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!

Labels
Top Solution Authors