community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Rank formula for boolean type fields

Asteroid

Hi,

 

I'm trying to build a multi-row formula for ranking my data as per below scenario:

If there is only 'False' for an account it should be ranked as 1. But, if there is  both True and False then, True should be ranked 1 and if only True then it is ranked 1. Also, Exception column is of boolean type

Account

Exception

12003456

False

63091267True
63091267False
32000156True
54670891True
54670891False
67890345False

 

Output

Account

Exception

Rank

12003456

False

1

63091267True1
63091267False2
32000156True1
54670891True1
54670891False2
67890345False1

 

Please help me with a formula. 

Thanks

Highlighted
Alteryx Certified Partner

Hi @Bhavika

 

Take a look at my solution. In Multi-row formula tool select the account field in the group by option. Hope it helps.

 

Rank_MR.PNG

Labels