Reporting Services: Two Tables One Sum

Question

My report is as follows:

One table provides financial information with sums at the group footer (Grouping is called "StockTable_Shipped"). The group is controlled by a boolean value (1=shows shipped data, 0 = shows received data)

The second table is a variance report for data that has been shipped (boolean value of 1) and has a sum at the bottom of the table.

My ultimate goal is to take the sum from table1 where shipped=1 and subtract it from the variance sum from table2.

This will be placed in a textbox at the bottom of the report.

I understand if this sounds confusing but I would be more then happy to provide more information.

Answer 1

If I were you, I would create a new calculated field which would hold the sum of all your Shipped Data (1's) not just the sum of all your data (1's and 0's).

After that, it should be as simple as putting in the expression that subtracts your calculated field from the Sum of your table2 field.