Manual Calculation versus Expression Calculation Not Matching

[pnn44794]

Hello:

I have a straight table and two text boxes.  Both text boxes do a Sum of quantity.  The straight table is nothing fancy with simply a column name as the sole expression.

When I export the straight table to Excel, filter it exactly as the Text box expressions, I get a different total than what is displayed in the text boxes.  For YQUANTITY in that text box I have a total of 444,818, but when I manually sum the Excel export, I get 552,417 or a difference of 107,599.  For the XQUANTITY in that text box, I have a total of 737,207, but when manually summed in the Excel export, I get 738,647 or a difference of 1,440.

The two expressions for the text boxes follow.  I've also attached some sample data which I've already filtered to match the following expressions.

Does anyone have any ideas what might be causing this?  As always, I appreciate any and all help and responses.  Thanks in advance.

[sunny_talwar]

Is this where you load the data from or is this the export from QlikView?

[pnn44794]

Hello Sunny:

This is the export from Qlikview.

[sunny_talwar]

Is it possible that not all of the fields within the table box might be coming from more than a single table?

[pnn44794]

The following is in a Text object and not a table box or am I misunderstanding you (certainly possible on my part)?

[pnn44794]

Sorry.  I didn't fully answer.  The fields all come from the same table.  For the Straight table, the fields come from two tables.

[sunny_talwar]

Your export Excel is a table box or straight table? If it is a straight table, are you may be suppressing negative values from the dimension or Dimension Limits tab?

[pnn44794]

Straight table.  I am not suppressing any values or at least not deliberately.

[sunny_talwar]

To tell you the truth, I am not sure what might be going

[pnn44794 · Accepted solution]

Thanks Sunny.  I appreciate you taking a look.  Sorry for the delay in getting back to you too.  Turns out, I had a problem with my data model and I was getting extra rows of data which caused the mismatch in the manual versus expression calculation.  It's fixed now.

Thanks again.