Alteryx Designer Desktop Discussions

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

getting max %

mzubair9402
6 - Meteoroid

Hi all,

 

I have a bunch of data in one column with numbers words percent and etc. I need to extract the max tax rate percent for each row. I tried the sum function but not all data being pulled is correct. Can you please help.

12 REPLIES 12
Maskell_Rascal
13 - Pulsar

Make sure that Date is selected in the Transpose Tool and Select Tools. Sometimes they drop off when downloading a workflow from another user. 

Maskell_Rascal_0-1624652168457.png

 

apathetichell
19 - Altair

Its' worth noting that the data you posted is fairly different than the data your workflow was designed for - that has an effect on the how the workflow is developed. Your workflow had text fields and needed the first 4 rows cut off to be used - the data you posted didn't need that work and was already numbers. This changes how the workflow is developed and the tools used - the key component though is getting a date/group field and getting the tax rates into a double format (whether natively or via multi-field) and then using a summarize.

mzubair9402
6 - Meteoroid

Thank you all for your help.

Labels
Top Solution Authors