
1. Re: Creating a SubTotal that is DIFFERENCE and not SUM
Joshua Cloud Apr 21, 2016 1:46 PM (in response to Gene Denny)Gene,
Is this what you are looking for?
I used the instructions on the below link to create the difference subtotal:
Re: How to do % difference function instead of sum for a row subtotal with multiple columns
The formula for the difference calculations looks like this:
IF FIRST() = LAST() THEN
SUM([ELA Percent A's & B's])
ELSE IIF(FIRST()==0,
( LOOKUP( SUM( [ELA Percent A's & B's] ) , LAST() )  LOOKUP( SUM( [ELA Percent A's & B's] ) , FIRST() ) ) , NULL )
END
I also turned on subtotals, instead of the grand totals as the above link shows, and computed both calculations with Endyear (copy).
It may be a bit complicated, so let me know if you need any clarification.
Cheers!

Sample_reshaped.twbx 45.7 KB


2. Re: Creating a SubTotal that is DIFFERENCE and not SUM
Gene Denny Apr 21, 2016 3:55 PM (in response to Joshua Cloud)Joshua, this is EXACTLY what I've been striving for and I sincerely appreciate not only your solution, but the full explanation and link as well!
Thank you SO much!