I have a huge data about 57 million rows and after cracking my head on it for one whole day, I (and my team) still could not find out the reason for the following discrepancy: I have a browse tool and summarize tool connected to the same data set as shown in first screen capture. The output of summarize tool shows 791 million pounds quantity. However, output of browse shows 70 million quantity as seen in the other 2 screen captures. There is no way to identify the true value due to the huge file. Any help would be appreciated.
Workflow:
Summarize Output:
Browse Output:
