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 

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

Output:

Hope this helps : )