
1. Re: Calling all Tableau Experts  Trying to subtract sumproduct totals from each other.
Jim Dehner Feb 13, 2019 12:19 PM (in response to Mike Lowry)Hi Mike
I am not an account but I did note this
Total is a table calculation and the table calculations are at the bottom of the order of operation after Grand Total
Suggest you replace Total (sum(avg bal)) with {fixed:sum(avg bal))
Jim
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.

2. Re: Calling all Tableau Experts  Trying to subtract sumproduct totals from each other.
Mike Lowry Feb 13, 2019 1:20 PM (in response to Jim Dehner)Hello Jim,
Thanks for your prompt reply!
The Yield final calculation is actually correct as it functions properly for the report; not sure doing this will help solve my issues of trying to subtract Assets vs Liabilities in the Total worksheet.
I need to figure out how to create a new calculated filed possibly and set some kind of tableau logic to subtract the two values from each other.... hope that makes sense.

3. Re: Calling all Tableau Experts  Trying to subtract sumproduct totals from each other.
Jim Dehner Feb 13, 2019 1:47 PM (in response to Mike Lowry)good luck
sorry didn't explain the goal here
the suggestion was to get you away from a table calculation with an LOD that would return the same values  once you are away from table calculations yo can us Grand Totals
Jim