We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Selection of customers that only have balances > 60 days

Cjackson02
5 - Atom

I have a customer list that includes open balances, however, I only want to select those accounts that have > 60 days balances.  I would expect the output here to be customer A4, A6 & A7.

 

Clearly I am quite new with Alteryx and it seems that there should be a simple solution or even something a simple tool could manage, but again....I am very "green" to the tools

 

Any suggestions would be wonderful!

 

 

Customeramountage category
A1              1,000> 60 days
A1                 100> 60 days
A1                    10< 60 days
A1              1,000>60 days
A2                 100> 60 days
A2                    10<60 days
A4           10,000> 60 days
A5           10,000<60 days
A6     1,000,000> 60 days
A7                 100> 60 days
3 REPLIES 3
Warcry
9 - Comet

Use the Filter tool and use this formula: [age category] = "> 60 days"

 

Also check you table to provided, your results are not possible because there several more that are > than 60 days. You need more criteria to get just those results.

Cjackson02
5 - Atom

Thank you.  However, the latter is what I'm trying to avoid.  I have customers who have both > & < 60 day balances.  However only want those customers with > 60 day balances only.

Warcry
9 - Comet

Based off what you are asking, there are more than just three results. Is there something I am not seeing here?

 

Please feel free to add more details it is hard to help if you are vague.

 
 

Screenshot 2025-03-06 212404.png

Labels
Top Solution Authors