7 Replies Latest reply on Jun 6, 2018 11:38 PM by Lewis Williams

# Difference in amounts between two consecutive dates

I'm hoping this is an easy one for someone. (I've been trying to figure it out for a few hours now). I collect transactional information (backers, amount, total backers and total amount) by ORG_ID every day.  I want to see the difference in total amount committed each day by ORG_ID as well as the percent change from one day to the next.

So if on June 1st ORG_ID = 1 had \$1,600 committed and on June 2nd they had \$3,200 committed, then the difference from June 1st to June 2nd would be (\$3,200 - \$1,600) = \$1,600 and if they had total amount of commitments of \$16,000 on June 1st and it increased to \$18,200 on June 2nd that would have been a (1 - \$18,200/\$16,600) = 13.75%. (I do understand the difference can be calculated by subtracting the total amount from one day to the next as well ... still not sure how to calculate that).

Hence for each ORG_ID I'd would like to see two columns. One that shows the \$ amount difference from one day to the next and the other that shows the % increase from one day to the next.

Thanks!

• ###### 1. Re: Difference in amounts between two consecutive dates

Like This?

• ###### 2. Re: Difference in amounts between two consecutive dates

Close .... I'm looking for the change in amount from one day to the next in one column and the % change in the second column and just show today's (june 4th)  yesterday's (june 3rd) results by Org ID

• ###### 3. Re: Difference in amounts between two consecutive dates

Is this what you are looking for?

Kind Regards,

Lewis

• ###### 4. Re: Difference in amounts between two consecutive dates

Yes ... that's pretty much what I'm looking for (I'd just remove the columns for Amount and Backers just so I see Difference Amount and % Difference in Backers. Can you tell me what to do?

• ###### 5. Re: Difference in amounts between two consecutive dates

Hi Sherwood,

Please find the attached twbx, hope it will help.

Regards,

Anupam

2 of 2 people found this helpful
• ###### 6. Re: Difference in amounts between two consecutive dates

Awesome! Thank you!! It worked!!

• ###### 7. Re: Difference in amounts between two consecutive dates

See the workbook attached