I have 2 rows and want to divide 1st row by 2nd row and get the result in the 3rd row
- 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
I have attached the workflow and the file I used as input for reference. If you run the workflow you can see the output as below. I want to divide 1st row by 2nd row (133/155) and get the output below that in the 3rd row. It would be a great help if anyone would provide a solution for this. Thanks.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @iamviraj13, you could use a Summarize tool and union it back to the original dataset. I have attached an updated version of your workflow.
Let us know if this helps.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @iamviraj13,
You'll want to use the Transform tools to reshape the data, perform this calculation, then Cross Tab the data into it's final format:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Clearly I wasn't concentrating when attempting to answer, sorry! Thank you @Aaron_Harter for keeping me honest.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks Aaron
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Aaron_Harter
This workflow was very useful for me. Thanks for the contribution!
