3 Replies Latest reply on Jun 20, 2016 7:45 AM by Yuriy Fal

    Calculate Percentage Based off Bucket from Previous Month

    Guillermo Trujillo

      Hey All,

       

      I'm trying to calculate the rate based off bucket number and sum of open balances by looking at prior month's column and next month's column.  Below is a sample table of what my data currently looks like.  Essentially, I'm attempting to get the roll rate by calculating the value from bucket 1 (let's say $456,789 from 2015-04) / previous month's bucket 0 ($123,456 from 2015-03).  Not exactly sure where to begin with this.  Any help is much appreciated.  Thank you.

      Bucket2015-032015-04
      2015-05
      0$123,456$789,012$345,678
      1$910,123$456,789$102,345
      2$678,901$234,567$890,123