Transpose messing up sub total
- 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,
In the below image the transpose tool is causing some of the data to drop out so it is not summing up correctly when i use the summarize tool
It's hard for me to post data as it's sensitive but I was wondering if it's a common issue and if there is a common fix for it.
This is how my summary tool is set up currently:
Thank you
Solved! Go to Solution.
- Labels:
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @chiragpatel_1
Can you provide some sample input and expected file output It will help us get a better understanding of the usecase.
We will be happy to help : )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
when i upload a workflow, will you be able to see that data as well?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
No, you need to provide an excel file and workflow or we wont able to run.
Hope this helps : )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Its falling over when is summarize, the figure for 202101 should be 33015, along those lines but the summarize tool only outputs 32991
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
The issue is with select tool assign datatype you need to select double instead of int
Output:
Hope this helps : )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you, such sneaky error, i spent hours investigating
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
True its happens
Happy to help : )
If my response helps please don't forget to mark it as solution.
Cheers and have a nice day!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Quick query - I have the following statement in snippet below for two specific account but for all other accounts I want the following condition to apply [Group 2] in ("GT","PS","GP","PT", "UM", "MC"), how would i go about adding that
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Filter formula would be
([Account] in ('V40823','V17312') and [Group 2] in ("GT","PS","GP","PT"))
OR
([Account] not in ('V40823','V17312') and [Group 2] in ("GT","PS","GP","PT", "UM", "MC"))
Hope this helps : )
