LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: jpstory

Hi All

I am trying to track changes of sales volumes for all accounts given.

An Excel file with daily sales volumes for 100+ Accounts at the month end, the Data Structure is: there are only 3 columns Date, Account and Volumes

I need to get the day-to-day change of the volumes for each account for the entire month.

Any suggestions on how to start?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ryeh

Use an Agg Ex node. If not already sorted, sort by Account and Date. Then use an Agg Ex node to keep track of the previous Volume and subtract that from the current row's Volume value.
Attachments:
volumeChange.brg

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: jpstory

Wow thanks! It's interesting how the looping works... I mean normally a for loop or while loop statement would be used for such calculations .