Transpose messing up sub total

[chiragpatel_1]

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

[atcodedog05]

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 : )

[chiragpatel_1]

when i upload a workflow, will you be able to see that data as well?

[atcodedog05]

Hi @chiragpatel_1 

No, you need to provide an excel file and workflow or we wont able to run.

Hope this helps : )

[chiragpatel_1]

Its falling over when is summarize, the figure for 202101 should be 33015, along those lines but the summarize tool only outputs 32991

[atcodedog05 · Accepted solution]

Hi @chiragpatel_1 

The issue is with select tool assign datatype you need to select double instead of int

Output:

Hope this helps : )

[chiragpatel_1]

Thank you, such sneaky error, i spent hours investigating

[atcodedog05 · Accepted solution]

Hi @chiragpatel_1 

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!

[chiragpatel_1]

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

[atcodedog05]

Hi @chiragpatel_1 

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 : )