
1. Re: LOD to calculate compounding interest
Zhouyi Zhang Jun 10, 2018 7:13 AM (in response to Bill Miller)Hi, Bill
Can you provide a sample workbook with mock up data?
ZZ

2. Re: LOD to calculate compounding interest
Bill Miller Jun 10, 2018 7:55 AM (in response to Zhouyi Zhang)Hi, Zhouyi Zhang,
Thanks for replying. This is the data I am working with.
As you can see from the data. The interest is growing first and then remain a constant in the rest year.
I used table calculation to compute the compounding interest but when I need to create a set to filter the "year" dimension, because the calculation is using table(down), it would turn out to be a wrong answer.
That's why I am trying to use LOD to replace the calculation, but I just can't think of the formula.
Do you have any idea? I need some inspirations...

Mock up.twb 55.5 KB


3. Re: LOD to calculate compounding interest
Ritesh Bisht Jun 10, 2018 9:10 AM (in response to Bill Miller)Please post twbx file.
Thanks,
Ritesh

4. Re: LOD to calculate compounding interest
Bill Miller Jun 10, 2018 11:21 AM (in response to Ritesh Bisht)Dear Ritesh,
Here's my .twbx file. Thanks for reminding.

Mock up.twbx 54.6 KB


5. Re: LOD to calculate compounding interest
Deepak Rai Jun 10, 2018 10:06 AM (in response to Bill Miller)Here it is. If you need to Filter, The Filter has been added to CONTEXT for filtering.
I used this data from here
Thanks
Deepak
Hope it Helps.

CI_v10.2.twbx 16.7 KB


6. Re: LOD to calculate compounding interest
Bill Miller Jun 10, 2018 9:33 PM (in response to Deepak Rai)Hi Deepak,
Thank you for your help. and it's the right calculation for a total amount of the compounding interest.
But in this case, I need to calculate the yearly compounding interest due and show it. And the data I have is the yearly interest payable.(You can check on my twbx. file above)

7. Re: LOD to calculate compounding interest
Zhouyi Zhang Jun 11, 2018 5:52 AM (in response to Bill Miller)Hi, Bill
Thanks for your workbook.
I guess you want to filter the year but keep the table calculation, if yes, please see my calculation for year filter, which convert the year filter as table calculation as well in this case.
Workbook attached for your reference.
Hope this helps
ZZ

Mock up_v10.2.twbx 38.2 KB


8. Re: LOD to calculate compounding interest
Bill Miller Jun 11, 2018 7:54 AM (in response to Zhouyi Zhang)Hi Zhouyi Zhang,
Thanks for your information. I have seen this formula before but still thanks!
I guess there is no formula to use LOD to calculate the yearly compounding interest
The table calculation with still be affected by "action" in the dashboard when you want to show the highlight of the yearly interest in a graph.
Or is there any method to make the table calculation not affected by "action"?