In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
Start Free Trial

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
binu_acs
21 - Polaris

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

image.png

Jenina
8 - Asteroid

@binu_acs  It works! Thanks as always 

Jenina
8 - Asteroid

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

binu_acs
21 - Polaris

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

image.png

Jenina
8 - Asteroid

@binu_acs  Got it, thank you!

Labels
Top Solution Authors