# Text NL - Financiële analyse - Ratio's

**URL:** <https://community.silverfin.com/t/text-nl-financiele-analyse-ratios/246>\
**Category:** Templates\
**Created:** [May 10, 2017, 1:40pm UTC](https://community.silverfin.com/t/text-nl-financiele-analyse-ratios/246 "2017-05-10T13:40:07Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![svalais](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/svalais/32/2422_2.png) [@svalais](https://community.silverfin.com/u/svalais)\
**Post date:** [May 10, 2017, 1:40pm UTC](https://community.silverfin.com/t/text-nl-financiele-analyse-ratios/246/1 "2017-05-10T13:40:07Z")

</div>

Hello,

In this text, I’m using the enddate of eacht financial year (period.year\_end\_date,period.minus\_1y.year\_end\_date,period.minus\_2y.year\_end\_date,…).

This is ok for a dossier with periodicity Year.

My problem is now is you have a dossier with periodicity Month (ex. 03/2017) or Quarter (Q1/2017), which code do I have to use to have above the colomun 03/2017 or Q1/2017?

---

<div class="post-metadata">

**Author:** ![sven](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/sven/32/1495_2.png) [@sven](https://community.silverfin.com/u/sven)\
**Post date:** [May 12, 2017, 12:43pm UTC](https://community.silverfin.com/t/text-nl-financiele-analyse-ratios/246/2 "2017-05-12T12:43:57Z")

</div>

Hello @svalais,

The variable you want, is this :

```auto
{{ period.end_date }}

```

A list of all the variables we use, can be find [here](https://github.com/GetSilverfin/sf-templates/blob/master/drops/period.md).

In your case, you’ll need a date-filter though, like this :

```auto
{{ period.end_date | date:'%m/%Y' }}

```

This will result in 06/2016 for instance. An overview of date-filters can be found [here](http://cheat.markdunkley.com/).

To show Q2 instead of 06/2016, is a little bit more tricky.

We have to run over all the period, and give each period a number (number of the month that is):

```auto
{% for month in period.month_end_dates %}
{% assign month_name = month | date:'%-m'%}{{ month_name }}
{% endfor %}

```

This will result in  
1  
2  
3  
4  
5  
6  
7  
8  
9  
10  
11  
12

The, you can use a if-statement to convert period 3 to Q3 for instance, just like this :

```auto
{% for month in period.month_end_dates %}
{% assign month_name = month | date:'%-m'%}
{% if month_name == '3' or month_name == '6' or month_name == '9' or month_name == '12' %}Q{{ month_name/3 | integer }}{% endif %}
{% endfor %}

```

this will result in Q1,Q2,Q3 and Q4.

Could you try with this ?

Let me know if you’re stuck.

---

<div class="post-metadata">

**Author:** ![svalais](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/svalais/32/2422_2.png) [@svalais](https://community.silverfin.com/u/svalais)\
**Post date:** [May 15, 2017, 9:26am UTC](https://community.silverfin.com/t/text-nl-financiele-analyse-ratios/246/3 "2017-05-15T09:26:34Z")

</div>

Hello,

This is not the result I need because we always taken the enddate of the financial year of the customer.

My problem is for a customer where we import amounts in each month of het financial year (for example 01/2016, 02/2016, 03/2016, …) this is not the enddate of the financial year but the date of each month.

Which code do I need to use?

Can we do a check on the field Report by?

Thanks,

Sylvie

---

<div class="post-metadata">

**Author:** ![svalais](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/svalais/32/2422_2.png) [@svalais](https://community.silverfin.com/u/svalais)\
**Post date:** [May 15, 2017, 1:42pm UTC](https://community.silverfin.com/t/text-nl-financiele-analyse-ratios/246/4 "2017-05-15T13:42:06Z")

</div>

Hello,

We are more and more working with situation and we have urgently need an answer because we are working with the ratio’s for the discussion with the client.

Thanks,

Sylvie

---

<div class="post-metadata">

**Author:** ![svalais](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/svalais/32/2422_2.png) [@svalais](https://community.silverfin.com/u/svalais)\
**Post date:** [June 1, 2017, 12:13pm UTC](https://community.silverfin.com/t/text-nl-financiele-analyse-ratios/246/5 "2017-06-01T12:13:48Z")

</div>

Hello,

When can I receive a answer?

Thanks,

Sylvie

---

<div class="post-metadata">

**Author:** ![sven](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/sven/32/1495_2.png) [@sven](https://community.silverfin.com/u/sven)\
**Post date:** [June 2, 2017, 8:27am UTC](https://community.silverfin.com/t/text-nl-financiele-analyse-ratios/246/6 "2017-06-02T08:27:43Z")

</div>

@svalais,

Could you explain me into detail what field exactly do you wish to display? I thought it was either the enddate of each period (solution is above) but your post 18 days ago suggests you need the enddate of the financial year?

Because that’s given as well.

Maybe you can post the whole code, so it becomes clearer? Sorry for the delay.

---

<div class="post-metadata">

**Author:** ![svalais](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/svalais/32/2422_2.png) [@svalais](https://community.silverfin.com/u/svalais)\
**Post date:** [June 2, 2017, 8:45am UTC](https://community.silverfin.com/t/text-nl-financiele-analyse-ratios/246/7 "2017-06-02T08:45:29Z")

</div>

hello,  
I will try it next week.  
Thanks,

Sylvie

---

<div class="post-metadata">

**Author:** ![svalais](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/svalais/32/2422_2.png) [@svalais](https://community.silverfin.com/u/svalais)\
**Post date:** [June 6, 2017, 11:24am UTC](https://community.silverfin.com/t/text-nl-financiele-analyse-ratios/246/8 "2017-06-06T11:24:02Z")

</div>

Hello,

It’s working but how can I test when the dossier is filling in month, quarter of year? Wat is the name of the field in the dossier properties?

Thanks,

Sylvie

---

<div class="post-metadata">

**Author:** ![sven](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/sven/32/1495_2.png) [@sven](https://community.silverfin.com/u/sven)\
**Post date:** [June 6, 2017, 2:25pm UTC](https://community.silverfin.com/t/text-nl-financiele-analyse-ratios/246/9 "2017-06-06T14:25:14Z")

</div>

Hello @svalais,

You can’t check on that, but isn’t this fixed by just using `{{ period.name }}` ?

---

<div class="post-metadata">

**Author:** ![svalais](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/svalais/32/2422_2.png) [@svalais](https://community.silverfin.com/u/svalais)\
**Post date:** [June 6, 2017, 2:53pm UTC](https://community.silverfin.com/t/text-nl-financiele-analyse-ratios/246/10 "2017-06-06T14:53:47Z")

</div>

Hello,

Thanks but I don’t need the information anymore.

Sylvie

---

<div class="post-metadata">

**Author:** ![sven](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/sven/32/1495_2.png) [@sven](https://community.silverfin.com/u/sven)\
**Post date:** [June 6, 2017, 3:28pm UTC](https://community.silverfin.com/t/text-nl-financiele-analyse-ratios/246/11 "2017-06-06T15:28:45Z")

</div>