# CASE: How to refer to accounts in specific account range at the end of the previous period **URL:** \ **Category:** Cases\ **Tags:** references, case\ **Created:** [June 29, 2017, 11:38am UTC](https://community.silverfin.com/t/case-how-to-refer-to-accounts-in-specific-account-range-at-the-end-of-the-previous-period/325 "2017-06-29T11:38:50Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Mathias](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/mathias/32/125_2.png) [@Mathias](https://community.silverfin.com/u/Mathias)\ **Post date:** [June 29, 2017, 11:38am UTC](https://community.silverfin.com/t/case-how-to-refer-to-accounts-in-specific-account-range-at-the-end-of-the-previous-period/325/1 "2017-06-29T11:38:50Z")
Silverfin can provide the value of an account at the end of a previous period. For this, you can use the following code: ```auto #15:1y ``` This will provide the value on the accounts (in the account range 15) one year ago. This works fine when the reporting is done on a yearly basis. But when monthly reporting is used, you could use the following code: ```auto period.minus_1y.year_end.accounts.15 ``` This code will provide you the value of the accounts (range 15) at the end of the previous book year. ---
**Author:** ![robin.bailleul](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/robin.bailleul/32/163_2.png) [@robin.bailleul](https://community.silverfin.com/u/robin.bailleul)\ **Post date:** [September 5, 2017, 12:15pm UTC](https://community.silverfin.com/t/case-how-to-refer-to-accounts-in-specific-account-range-at-the-end-of-the-previous-period/325/2 "2017-09-05T12:15:13Z")
Hi @Mathias, Is there also a way to access the actual _previous_ period, i.e. the period _right before_ the current one? e.g. for a monthly reporting client, when I am in the period for March, I want to access the period for February, etc. Thanks in advance. BR, Robin ---
**Author:** ![SamVanEenoo](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/samvaneenoo/32/134_2.png) [@SamVanEenoo](https://community.silverfin.com/u/SamVanEenoo)\ **Post date:** [September 5, 2017, 12:28pm UTC](https://community.silverfin.com/t/case-how-to-refer-to-accounts-in-specific-account-range-at-the-end-of-the-previous-period/325/3 "2017-09-05T12:28:26Z")
Hi Robin You can accomplish this by using #15:1p or period.minus\_1p.accounts.15 Kind regards Sam ---
**Author:** ![robin.bailleul](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/robin.bailleul/32/163_2.png) [@robin.bailleul](https://community.silverfin.com/u/robin.bailleul)\ **Post date:** [April 27, 2018, 1:59pm UTC](https://community.silverfin.com/t/case-how-to-refer-to-accounts-in-specific-account-range-at-the-end-of-the-previous-period/325/4 "2018-04-27T13:59:29Z")
Hi, It is currently not possible to use any of these notations in the reports: the ‘:’ sign is not accepted as input. ---
**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:** [April 27, 2018, 2:02pm UTC](https://community.silverfin.com/t/case-how-to-refer-to-accounts-in-specific-account-range-at-the-end-of-the-previous-period/325/5 "2018-04-27T14:02:51Z")
Hey @robin.bailleul, I’m not sure if I follow, because above case is not about inputs but about values of accounts. Could you give us a little bit more input (no pun intended 😉 ) ? Thanks. ---
**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:** [April 27, 2018, 2:05pm UTC](https://community.silverfin.com/t/case-how-to-refer-to-accounts-in-specific-account-range-at-the-end-of-the-previous-period/325/6 "2018-04-27T14:05:35Z")
Wait, you probably mean reports right, instead of Liquid-templates ? If so, that is indeed not possible but it shouldn’t be because you can add an extra period which gives you the desired number, through the drag-and-drop function to add periods. Or did you wish to calculate with it in a formula? ---
**Author:** ![robin.bailleul](https://yyz2.discourse-cdn.com/flex030/user_avatar/community.silverfin.com/robin.bailleul/32/163_2.png) [@robin.bailleul](https://community.silverfin.com/u/robin.bailleul)\ **Post date:** [May 2, 2018, 7:05am UTC](https://community.silverfin.com/t/case-how-to-refer-to-accounts-in-specific-account-range-at-the-end-of-the-previous-period/325/7 "2018-05-02T07:05:57Z")
Hi @sven, I appologize for the lack of clarity in my previous post. I did indeed mean to use this notation to acquire the value of an account(range) at the end of a previous period, to use in calculations in formulas in reports. ---
**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 6, 2018, 12:37pm UTC](https://community.silverfin.com/t/case-how-to-refer-to-accounts-in-specific-account-range-at-the-end-of-the-previous-period/325/8 "2018-05-06T12:37:16Z")
Hey @robin.bailleul, For now not possible indeed (however, this has been added as a feature request). If you want to know the status of this, be sure to ask this through our chat or [support@silverfin.com](mailto:support@silverfin.com) But, you should be able to have a workaround where you calculate the formula through liquid. Take the outcome of that into a result, so you can link that number into a report. Here an example: > [@Link existing template to new report](https://community.silverfin.com/t/link-existing-template-to-new-report/558/2): > > Hello @Dons, Seems to me we overlooked this topic, because we are not automatically triggered for this category (we now are). Our apologies. first of al, in your recon template the result of ‘geldboeten’ needs to have a result-tag, f.i. : Geldboeten = {{ $23 | currency }}{% result 'geldboeten' $23 %} So by adding the code {% result 'geldboeten' $23 %} it actually makes it able to link that result (saved i that register $23) in another template. Also, a handle is needed in the recon-template… Hope this helps