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

# Calculate Percentage Based off Bucket from Previous Month

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
• ###### 1. Re: Calculate Percentage Based off Bucket from Previous Month

Hi Guillermo,

Have no idea about a purpose, anyway ...

The trick is in using nested LOOKUP() Table Calcs.

They are [Amount (inner)] and [Amount (outer)].

The former is Compute using [Bucket], the latter is along [Date].

Please take a look at the Addressing & Partitioning of these TC on a view.

Hope it could help.

Yours,

Yuri

• ###### 2. Re: Calculate Percentage Based off Bucket from Previous Month

Thank you Yuriy!  This actually worked perfectly.

• ###### 3. Re: Calculate Percentage Based off Bucket from Previous Month

Guillermo, you're welcome.