This content has been marked as final.
Show 2 replies

1. Re: Sum of rowlevel differences over time
Deepak Rai Jul 20, 2018 12:04 PM (in response to Eric Pynnonen)Will this not Help?
LOOKUP(SUM([# of Problems]),0) –LOOKUP(SUM([# of Problems]),1)
Or You may use Quick calculation to Find Difference from Previous

2. Re: Sum of rowlevel differences over time
Eric Pynnonen Jul 20, 2018 12:14 PM (in response to Deepak Rai)I've tried that, but it doesn't work because it cancels out all the instances of problem counts going up, then back down again, instead of adding them both together.
What I need is the difference calculation performed first (at the row/item level), then the absolute value operation (to prevent the cancellingout issue), then the aggregation.