Sum not matching sum on browse tool

Question

Im trying to get a split % per subscriber. Each subscriber has their own usage amount by MB. My plan was to use a sum tool to total the MB usage column, then append it, then use a formula to divide each individual usage amount by the total. I'm coming across a couple issues here and need some help. The sum tool tells me I have 48 billion mb, however, the browse tool says I have 436 million mb when I click on the column. Then I tried to filter out the 0's but that still is not the same value. I honestly dont even know which value is actually correct here. After my split formula, the total amount for that column should also be 1, which it isnt. My initial data type was fixed decimal, then I changed it to double and that still didnt fix the issue. Does anyone have a solution for this?

sirelandcbre · Answer

Depending how close you are to that 300MB, I wonder if the MB shown was the persistent compressed yxdb file size saved to disk as opposed to the MB of RAM required to keep the uncompressed data preview in memory?

maygross · Answer

Thats actually super helpful to know, my data is 364 MB in the browse tool. However, when i filter out 0's and then browse, its under 300 MB but the total is still different from the sum tool... Also, I still have the issue of my split total not equaling 1. Any other ideas?

Hsolmaz · Answer

If your data exceeds the 300 MB limit in the Browse tool during Data Profiling, You should rely on the Summarize tool instead. Here