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