getting max %

[mzubair9402]

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.

[Maskell_Rascal · Accepted solution]

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

[apathetichell · Accepted solution]

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]

Thank you all for your help.