# Show capital repayments of previous years in evolution table

**URL:** https://community.silverfin.com/t/show-capital-repayments-of-previous-years-in-evolution-table/2406
**Category:** Reports
**Tags:** variables
**Created:** [February 16, 2023, 1:27pm UTC](https://community.silverfin.com/t/show-capital-repayments-of-previous-years-in-evolution-table/2406 "2023-02-16T13:27:18Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Maarten](https://avatars.discourse-cdn.com/v4/letter/m/ecccb3/32.png) [@Maarten](https://community.silverfin.com/u/Maarten)
#### Post date: [February 16, 2023, 1:27pm UTC](https://community.silverfin.com/t/show-capital-repayments-of-previous-years-in-evolution-table/2406/1 "2023-02-16T13:27:18Z")

</div>

Is it possible to automatically display the capital repayments of previous years in the evolution table?  
In my report i’m trying with the formula reconciliations.kredieten.results.done\_prepayments.value  
but this is not working.

 ![image](https://canada1.discourse-cdn.com/flex030/uploads/getsilverfin/original/2X/4/4d2f16ce58c58132fac7f9155fe33e4f84f8a784.png)

---

<div class="post-metadata">

### Author: ![Maarten](https://avatars.discourse-cdn.com/v4/letter/m/ecccb3/32.png) [@Maarten](https://community.silverfin.com/u/Maarten)
#### Post date: [February 16, 2023, 1:27pm UTC](https://community.silverfin.com/t/show-capital-repayments-of-previous-years-in-evolution-table/2406/2 "2023-02-16T13:27:38Z")

</div>

In the preview of the amortisation table the repayments are displayed

 ![image](https://canada1.discourse-cdn.com/flex030/uploads/getsilverfin/original/2X/c/c3ca5b71b57a8b75f233caf8203941cc46206ce3.png)

and if i edit the reconciliation i think the “totaal\_kapitaal\_vv” is displaying the data  
code here below

| | | {{ dent2 }}{{font\_header}} **{{ ‘Vervroegde Terugbetalingen’ | upcase }}** {{end\_font}} | | {% if emz %} | {%endif%}  
{% for i in (ditjaar\_index…ditjaar\_index+number\_of\_years-1) %}  
{% assign j = jaren\_chron[i] | remove:‘.’ %}  
{% assign totaal\_kapitaal\_vv = ‘totaalkapitaal’ | append:j | append:‘vv’ %}  
{% assign totaal\_intrest\_vv = ‘totaalintrest’ | append:j | append:‘vv’ %}  
{{font}}**{{ [totaal\_kapitaal\_vv] | currency }}**{{end\_font}} |  
{{font}}**{{ [totaal\_intrest\_vv] | currency }}**{{end\_font}} |  
{% if forloop.first %} | {%endif%}  
{%endfor%}  
{% endif %}

---

<div class="post-metadata">

### Author: ![Kimberly\_Vlietinck](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/kimberly_vlietinck/32/1496_2.png) [@Kimberly\_Vlietinck](https://community.silverfin.com/u/Kimberly_Vlietinck)
#### Post date: [February 20, 2023, 9:03am UTC](https://community.silverfin.com/t/show-capital-repayments-of-previous-years-in-evolution-table/2406/3 "2023-02-20T09:03:23Z")

</div>

Hi @Maarten,

First of all welcome to the Silverfin Developer Community!

Is my understanding correct that you are trying to present a result coming from a reconciliation template in your report?

As explained here, you can indeed display results from a reconciliation template in a report:

> [@CASE: display results from reconciliation in a report](https://community.silverfin.com/t/case-display-results-from-reconciliation-in-a-report/1206):
>
> As explained here, you can take amounts into a result tag to display somewhere else: Let’s say we have a template with a handle “stocks” and there’s a value taken into a result tag called “stock\_value”. How can we display this result tag in a report template? This is the way: Add a formula box to the report [07] As formula you’ll link to the result tag So that’s reconciliations.stocks.results.stock\_value without the period in the formula!

So in order to use this, you need to make sure that you have created a result in your template and use the correct result name to fetch the value in the report.

In the code snippet you shared I don’t yet see a result that is created for the value of the “totaal\_kapitaal\_vv”.  
Here you can find some more information on how you create a result:

> [@CASE reference values across templates by using result tags](https://community.silverfin.com/t/case-reference-values-across-templates-by-using-result-tags/1157):
>
> If you want to reference a certain value or variable from recon template A in another template, there’s a way to do it with the so-called result tags in STL. They work like this (bulb just type in result and press TAB to get this preformatted code bulb): {% result 'name' content %} where the name is a shortname you can choose, and the content is the value or variable you want to reference to. Let’s say we have this variable done\_prepayments in our recon template Prepayments (which is al…

Let me know if this works out for you or if you have any additional questions.

Kind regards,  
Kimberly

#result #result-tags #Reports
