Thanks for the reply!
Hmmm I can't quite get it to work on my side. When I create the DIFFERENCE calculation is does the difference before the running total table calc. I see your DIFFERENCE calculation has a table calc icon on it. Are you doing anything after the calc is dropped on the Measures Value shelf?
It has a table calc delta symbol because it is utilizing the running total table calc. Its hard to say what you are doing without actually seeing the workbook. If you can attach your workbook with the sample data, I am sure someone can assist.
Thanks again for your help. I could recreate what you did if I recreate my data values in excel and then pull the excel table into Tableau. However it's not working against my data source and all of the other calculated fields I have in my workbook. I've opened a case with Tableau Support to see if they can help me. If we can find a solution I will post it here.
Ok Tableau Support helped me isolate the step I was missing. This is what I ended up doing:
(1) Created a calculation called "Difference" with the following code:
SUM(Closing Balance) - RUNNING_SUM(SUM(New Customers))
(2) Dragged the "Difference" calculation to the "Measure Values"
(3) You will see the Table Calculation symbol appear. I then make sure to change the field to Compute using > Fiscal Quarter
Thanks again for your help!