Calculating a percentage of change from one day to the other
I'm working on a report that is grouped by date. What I'm trying to is calculate the difference between one day to the next. But when I try to do the formula it's thinks it's calculating against itself...
Group by Date: 9/1 = $100
9/2 = $80
Subtotal = =0.20%
Please give the formula details to check. I think you are not multiplied with 100 in your formula.