# Requesting figures from the year 2016 when you are in 2017

**URL:** https://community.silverfin.com/t/requesting-figures-from-the-year-2016-when-you-are-in-2017/1036
**Category:** Templates
**Tags:** drops, drop\_period
**Created:** [July 4, 2018, 4:37pm UTC](https://community.silverfin.com/t/requesting-figures-from-the-year-2016-when-you-are-in-2017/1036 "2018-07-04T16:37:43Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![NickS](https://avatars.discourse-cdn.com/v4/letter/n/4af34b/32.png) [@NickS](https://community.silverfin.com/u/NickS)
#### Post date: [July 4, 2018, 4:37pm UTC](https://community.silverfin.com/t/requesting-figures-from-the-year-2016-when-you-are-in-2017/1036/1 "2018-07-04T16:37:43Z")

</div>

Hi Sam,

In the model I’m building, I need figures from the 2nd previous year.  
(in silverfin I am in the year 2017)  
Current year is 2018  
1st previous year is 2017  
2nd previous year is 2016

The formula is:  
Increase/decrease in liquidity = X of year Y – X of year (Y-1)  
X = the amount of, for example ledger number 140000  
Y = 1st previous year 2017  
(Y-1) = 1st previous year 2017 - 1 is the year 2016

If X of year Y-1 is empty, then X is equal to 0.

Do you know how I can request figures from the year 2016 when I’m in 2017.

Thanks.

---

<div class="post-metadata">

### Author: ![robindeclercq](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/robindeclercq/32/472_2.png) [@robindeclercq](https://community.silverfin.com/u/robindeclercq)
#### Post date: [July 5, 2018, 7:21am UTC](https://community.silverfin.com/t/requesting-figures-from-the-year-2016-when-you-are-in-2017/1036/2 "2018-07-05T07:21:15Z")

</div>

Hi @NickS,

Unless I’ve misunderstood your question, you can easily get the figures from the 2nd previous year by ‘period.minus\_2y.accounts’, e.g.:

> {% assign revenue\_minus2 = period.minus\_2y.accounts | range:“70” %}
> 
> {{ revenue\_minus2 }}

Kind regards,  
Robin

---

<div class="post-metadata">

### Author: ![NickS](https://avatars.discourse-cdn.com/v4/letter/n/4af34b/32.png) [@NickS](https://community.silverfin.com/u/NickS)
#### Post date: [July 6, 2018, 5:31am UTC](https://community.silverfin.com/t/requesting-figures-from-the-year-2016-when-you-are-in-2017/1036/3 "2018-07-06T05:31:45Z")

</div>

Hi @robindeclercq

Thank you.😃
