getting max %
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
Solved! Go to Solution.
- Labels:
- Datasets
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Make sure that Date is selected in the Transpose Tool and Select Tools. Sometimes they drop off when downloading a workflow from another user.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you all for your help.

- « Previous
-
- 1
- 2
- Next »