Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Find MAX value and reassigning values

wlee-pwc
7 - Meteor

I am trying to do the equivalent of the excel formula shown on the attached screenshoot.  Picking the highest percentage value and on the next column assigning the highest value as 100%.  If possible group by company number and by state as well.  Thank you in advance.

 

 

1 REPLY 1
Thableaus
17 - Castor
17 - Castor

Hi @wlee-pwc 

 

Here's what I thought:

Solution2.PNG

 

1) Get Max Percentage

2) Join it to the Original Dataset with Join Multiple

3) Creates a formula stating that if the value is not null, then assumes 100%, else, it's not the max value so is 0%.

4) Format to Percentage String 

 

If you want to group by Company and State, add the Group By labels in step 1 to the Summarize Tool, and also add join clauses by Company and State in step 2.

 

Workflow appended.

 

Cheers,

Labels