# \#if **URL:** https://community.silverfin.com/tag/if/229.md [Latest](https://community.silverfin.com/latest.md) · [Categories](https://community.silverfin.com/categories.md) · [Tags](https://community.silverfin.com/tags.md) --- ## [CASE: calculate provision, depending on fiscal year](https://community.silverfin.com/t/case-calculate-provision-depending-on-fiscal-year/1296)
**Author:** [@sven](https://community.silverfin.com/u/sven)\ **Replies:** 0\ **Last updated:** [December 2, 2018, 1:00pm UTC](https://community.silverfin.com/t/case-calculate-provision-depending-on-fiscal-year/1296 "2018-12-02T13:00:11Z")
In this case, we show how an account template can be created, that calculates the provision. Depending on which fiscal year it is, it will take into account a certain percentage: Below is the source code; additional … --- ## [Conditional summing](https://community.silverfin.com/t/conditional-summing/1101)
**Author:** [@Bart\_Verhaeghe](https://community.silverfin.com/u/Bart_Verhaeghe)\ **Replies:** 0\ **Last updated:** [August 8, 2018, 12:54pm UTC](https://community.silverfin.com/t/conditional-summing/1101 "2018-08-08T12:54:15Z")
Hi, In case one of my colleagues might need to make a conditional sum: Doel: de voorwaardelijke som maken van een array gebaseerd op een andere array {% comment %}A = 25, B = 7, C = 8, D = 3{% endcomment %} {% as… --- ## [CASE: check if a reconciliation has been starred in the working papers or not](https://community.silverfin.com/t/case-check-if-a-reconciliation-has-been-starred-in-the-working-papers-or-not/600)
**Author:** [@sven](https://community.silverfin.com/u/sven)\ **Replies:** 0\ **Last updated:** [January 19, 2018, 8:08am UTC](https://community.silverfin.com/t/case-check-if-a-reconciliation-has-been-starred-in-the-working-papers-or-not/600 "2018-01-19T08:08:19Z")
There is now a method to check if a reconciliation has been starred or not in the working papers. You can check by this code : {% if period.reconciliations.verworpen\_uitgaven.starred? == true %} Some logic {% endif %} … --- ## [Control Flow Tag IF / ELSE](https://community.silverfin.com/t/control-flow-tag-if-else/2260)
**Author:** [@Vanmarcke\_ZKT](https://community.silverfin.com/u/Vanmarcke_ZKT)\ **Replies:** 2\ **Last updated:** [March 21, 2022, 12:41pm UTC](https://community.silverfin.com/t/control-flow-tag-if-else/2260 "2022-03-21T12:41:30Z")
The if/else code isn’t working. I would like when the result of | = Liquiditeitstest ratio | {{ -total\_value/benefit\_in\_kind\_range3 | currency }} is bigger than 1 that the text “Uit de balansbenadering blijkt dat er n… --- ## [Unreconciled + If statement](https://community.silverfin.com/t/unreconciled-if-statement/2166)
**Author:** [@Zena](https://community.silverfin.com/u/Zena)\ **Replies:** 3\ **Last updated:** [November 22, 2021, 3:11pm UTC](https://community.silverfin.com/t/unreconciled-if-statement/2166 "2021-11-22T15:11:12Z")
Hi everyone I want to use an unreconciled tag in combination with an IF statement. This is my IF statement: {%if maxturnover \> maxwage %}{{ maxwage | currency}} {% endif %} {% if maxturnover \< maxwage %}{{ maxturnover… --- ## [Beginner \[Exercise 5: Control flow\] (Training slides exercise)](https://community.silverfin.com/t/beginner-exercise-5-control-flow-training-slides-exercise/1737)
**Author:** [@borjaGonzalez](https://community.silverfin.com/u/borjaGonzalez)\ **Replies:** 1\ **Last updated:** [April 7, 2020, 10:25am UTC](https://community.silverfin.com/t/beginner-exercise-5-control-flow-training-slides-exercise/1737 "2020-04-07T10:25:56Z")
Create 2 input fields that allow the user to enter a budget value and an actual one and build an if statement that will display the following text depending on the value entered by the user. If both values are blank: … --- ## ["Brutomarge" on "jaarverslag"](https://community.silverfin.com/t/brutomarge-on-jaarverslag/1406)
**Author:** [@WendyVerbiest](https://community.silverfin.com/u/WendyVerbiest)\ **Replies:** 1\ **Last updated:** [February 27, 2019, 8:10am UTC](https://community.silverfin.com/t/brutomarge-on-jaarverslag/1406 "2019-02-27T08:10:35Z")
Hello, I wanted to change te code of the “jaarverslag” so that the accountnumbers 61 would be included in the “brutomarge” instead of in the “bedrijfsresultaat”. I tought dragging the line from under the “brutomarge” t… --- ## [How to use the outcome of an IF-formula in a new formula](https://community.silverfin.com/t/how-to-use-the-outcome-of-an-if-formula-in-a-new-formula/1398)
**Author:** [@sylvia.debaeremaeker](https://community.silverfin.com/u/sylvia.debaeremaeker)\ **Replies:** 1\ **Last updated:** [February 21, 2019, 12:48pm UTC](https://community.silverfin.com/t/how-to-use-the-outcome-of-an-if-formula-in-a-new-formula/1398 "2019-02-21T12:48:53Z")
Hi I want to calculate the ‘Beschikbaar vermogen’. Therefor i need to deduct the calculated ‘Liquidatiebelasting’ and ‘Inflatie’ from the ‘Verwacht EV op pensioenleeftijd’. The result of ‘Inflatie’ is calculated via a… --- ## [Autofill check box](https://community.silverfin.com/t/autofill-check-box/1376)
**Author:** [@neilmiller](https://community.silverfin.com/u/neilmiller)\ **Replies:** 2\ **Last updated:** [February 7, 2019, 10:22am UTC](https://community.silverfin.com/t/autofill-check-box/1376 "2019-02-07T10:22:56Z")
Hello, I have the following bit of code: | {% input period.custom.CPSignoffC5.criteria as:select options:“As Manager I confirm the assignmnet DOES require an aduit:|As Manager I confirm the assignmnet DOES NOT require … --- ## [If statement relating to reconciliation or indicator value](https://community.silverfin.com/t/if-statement-relating-to-reconciliation-or-indicator-value/1337)
**Author:** [@neilmiller](https://community.silverfin.com/u/neilmiller)\ **Replies:** 2\ **Last updated:** [January 9, 2019, 4:26pm UTC](https://community.silverfin.com/t/if-statement-relating-to-reconciliation-or-indicator-value/1337 "2019-01-09T16:26:11Z")
Hi, I am trying to get something to happen based on a question being reconciled or not. So when a question is reconciled we would like the name of the person and the date to appear next to the question. If the question… --- ## [Template works by costs but not by incomes](https://community.silverfin.com/t/template-works-by-costs-but-not-by-incomes/1323)
**Author:** [@Evelyne](https://community.silverfin.com/u/Evelyne)\ **Replies:** 2\ **Last updated:** [December 17, 2018, 4:08pm UTC](https://community.silverfin.com/t/template-works-by-costs-but-not-by-incomes/1323 "2018-12-17T16:08:43Z")
Hi, I’ve created a template for making a detail of the “regular costs and incoms”, but now I see that I only can ad an attachment (file) by costs and not by incoms… Can somebody help me with this? {% t= "Bedrag" fr:"M… --- ## [SF\_show\_inputs vs 'empty' bold table input cells](https://community.silverfin.com/t/sf-show-inputs-vs-empty-bold-table-input-cells/1221)
**Author:** [@jhanley](https://community.silverfin.com/u/jhanley)\ **Replies:** 9\ **Last updated:** [October 1, 2018, 12:41pm UTC](https://community.silverfin.com/t/sf-show-inputs-vs-empty-bold-table-input-cells/1221 "2018-10-01T12:41:05Z")
Hi, I’m trying to create a table with multiple input cells, some of which are bold. When the template is signed off as completed by the user (via a boolean), the input cells will then lock down using {% assign sf\_show\_i… --- ## [Limitations on dates chosen in date input](https://community.silverfin.com/t/limitations-on-dates-chosen-in-date-input/1224)
**Author:** [@Bart\_Verhaeghe](https://community.silverfin.com/u/Bart_Verhaeghe)\ **Replies:** 1\ **Last updated:** [October 1, 2018, 12:09pm UTC](https://community.silverfin.com/t/limitations-on-dates-chosen-in-date-input/1224 "2018-10-01T12:09:47Z")
Good morning, Is it possible to programatorically put limitations on the date range that can be chosen on a date input (e.g. when the date for a meeting has to be set within three months from now, that the calender can … --- ## [Determining a date from the format 'Xth Day Of Yth Month' (e.g. general assembly)](https://community.silverfin.com/t/determining-a-date-from-the-format-xth-day-of-yth-month-e-g-general-assembly/1152)
**Author:** [@Bart\_Verhaeghe](https://community.silverfin.com/u/Bart_Verhaeghe)\ **Replies:** 1\ **Last updated:** [August 26, 2018, 3:09pm UTC](https://community.silverfin.com/t/determining-a-date-from-the-format-xth-day-of-yth-month-e-g-general-assembly/1152 "2018-08-26T15:09:26Z")
Hi Sam, Sven, I worked out a function to determine the Xth Day of the Yth Month (e.g. to determine the date corresponding to the date of the general assembly of shareholders coupled to a given book year), where this dat… --- ## [Check whether an input in bedrijfsparameters has a value](https://community.silverfin.com/t/check-whether-an-input-in-bedrijfsparameters-has-a-value/829)
**Author:** [@Bart\_Verhaeghe](https://community.silverfin.com/u/Bart_Verhaeghe)\ **Replies:** 2\ **Last updated:** [April 19, 2018, 11:36am UTC](https://community.silverfin.com/t/check-whether-an-input-in-bedrijfsparameters-has-a-value/829 "2018-04-19T11:36:53Z")
Hi, in a template, I’m adding the name for the ‘wettelijke vertegenwoordiger’ (persoon.custom.represented\_by\_name). However, when I look at the template ‘bedrijfsparameters’, a name has not always been provided. As such… --- ## [Forloop with if-statement table layout](https://community.silverfin.com/t/forloop-with-if-statement-table-layout/821)
**Author:** [@Thijs](https://community.silverfin.com/u/Thijs)\ **Replies:** 14\ **Last updated:** [April 13, 2018, 6:29am UTC](https://community.silverfin.com/t/forloop-with-if-statement-table-layout/821 "2018-04-13T06:29:55Z")
The layout of a table is lost with following code: Code : |Wagen|Nummerplaat|Chassis|1e inschrijving|CO2|Fiscaal|Out op {% for wagenpark in company.custom.wagenpark %}{% capture wagenin %}{{ wagenpark.in-0 }}{% endcapt… --- ## [How to retrieve historical information in details](https://community.silverfin.com/t/how-to-retrieve-historical-information-in-details/664)
**Author:** [@Bart\_Verhaeghe](https://community.silverfin.com/u/Bart_Verhaeghe)\ **Replies:** 8\ **Last updated:** [March 6, 2018, 2:13pm UTC](https://community.silverfin.com/t/how-to-retrieve-historical-information-in-details/664 "2018-03-06T14:13:09Z")
Hi, Suppose I have a template with some details regarding the historical purchase of some stocks. Example: Date Stock Action Amount Cumulative 1/10/2013 A Purchase 100 100 10/10/2013 B Purchase 50 50 1/05/… --- ## [Link to select - true](https://community.silverfin.com/t/link-to-select-true/693)
**Author:** [@VDVLiesbet](https://community.silverfin.com/u/VDVLiesbet)\ **Replies:** 2\ **Last updated:** [March 2, 2018, 7:16am UTC](https://community.silverfin.com/t/link-to-select-true/693 "2018-03-02T07:16:10Z")
Hi I’m just starting and I have a problem. If the select is “true” I want to have the text in yellow, but when it’s false I don’t want the text there. What I’m I doing wrong?   \*\*De geraamde belasting\*\* hierop be… --- ## [Adjusting template 'verworpen uitgaven' from 17 to 40%](https://community.silverfin.com/t/adjusting-template-verworpen-uitgaven-from-17-to-40/634)
**Author:** [@Pieter1](https://community.silverfin.com/u/Pieter1)\ **Replies:** 4\ **Last updated:** [February 23, 2018, 12:48pm UTC](https://community.silverfin.com/t/adjusting-template-verworpen-uitgaven-from-17-to-40/634 "2018-02-23T12:48:21Z")
We have our own template to calculate the “verworpen uitgaven” In this template we use 17% for “de voordelen alle aard” of cars. This should be adjusted to 40%. Is this possible by simply adjusting the amounts below fro… --- ## [Export - Disclosure on new page](https://community.silverfin.com/t/export-disclosure-on-new-page/597)
**Author:** [@svalais](https://community.silverfin.com/u/svalais)\ **Replies:** 3\ **Last updated:** [January 18, 2018, 11:49am UTC](https://community.silverfin.com/t/export-disclosure-on-new-page/597 "2018-01-18T11:49:41Z")
Is it possible to start a specific disclosure on a new page in an export? --- ## [What to show if the answer is 0,00](https://community.silverfin.com/t/what-to-show-if-the-answer-is-0-00/164)
**Author:** [@Fiduciaire.Eulaers](https://community.silverfin.com/u/Fiduciaire.Eulaers)\ **Replies:** 7\ **Last updated:** [October 18, 2017, 6:55am UTC](https://community.silverfin.com/t/what-to-show-if-the-answer-is-0-00/164 "2017-10-18T06:55:53Z")
I’ve been searching but it seems that I can’t find the answer I need. We added some reconsiliation templates for our “eenmanszaken”. For example we made one for each “cost” (64, 65, 66). At the moment, if there are no… --- ## [How to use a list of all investments](https://community.silverfin.com/t/how-to-use-a-list-of-all-investments/328)
**Author:** [@Matthijs](https://community.silverfin.com/u/Matthijs)\ **Replies:** 13\ **Last updated:** [September 7, 2017, 12:28pm UTC](https://community.silverfin.com/t/how-to-use-a-list-of-all-investments/328 "2017-09-07T12:28:47Z")
Hi, I’m making a document where i want to have/create a list of all new investments in a year. These investment are already explained in the details in the right account but i want them to use in another document. So i… --- ## [Adaptting "Jaarverslag" - If / if / Else](https://community.silverfin.com/t/adaptting-jaarverslag-if-if-else/294)
**Author:** [@Sven.G](https://community.silverfin.com/u/Sven.G)\ **Replies:** 8\ **Last updated:** [June 22, 2017, 9:48am UTC](https://community.silverfin.com/t/adaptting-jaarverslag-if-if-else/294 "2017-06-22T09:48:46Z")
Hi there, I’ve start to adapt the “Jaarverslag” by adding some code. I want to ask my users to choose if between 2 choses, if not chosen one of them, it needs to give the same tekst. After trial and Error, I came to t… --- ## [Checking if input as:file is empty](https://community.silverfin.com/t/checking-if-input-as-file-is-empty/262)
**Author:** [@robin.bailleul](https://community.silverfin.com/u/robin.bailleul)\ **Replies:** 2\ **Last updated:** [June 2, 2017, 11:22am UTC](https://community.silverfin.com/t/checking-if-input-as-file-is-empty/262 "2017-06-02T11:22:24Z")
Hi, In a template, I would like to be able to check if a input for an attachement/file is empty or not. i.e., if I have an input tag {% input custom.foo.bar as:file%} I want to check if a file has been provided or … --- ## [List of references](https://community.silverfin.com/t/list-of-references/283)
**Author:** [@EBe](https://community.silverfin.com/u/EBe)\ **Replies:** 1\ **Last updated:** [May 29, 2017, 7:35am UTC](https://community.silverfin.com/t/list-of-references/283 "2017-05-29T07:35:59Z")
Is there somewhere a list of the usable references ? For example if I choose a different {Company\_Form} the parameter in reports are going to change. The term of a shareholder in a BVBA is different from one in a NV. … --- ## [CASE: how to use {% if forloop.first %} and/or {% if forloop.last %}](https://community.silverfin.com/t/case-how-to-use-if-forloop-first-and-or-if-forloop-last/21)
**Author:** [@sven](https://community.silverfin.com/u/sven)\ **Replies:** 0\ **Last updated:** [January 19, 2017, 12:52pm UTC](https://community.silverfin.com/t/case-how-to-use-if-forloop-first-and-or-if-forloop-last/21 "2017-01-19T12:52:56Z")
Got a question the other day, why we often use {% if forloop.first %} and / or {% if forloop.last %} in our account-templates. We use this, if we don’t want to display a certain loop. For instance, if we have an overvie… --- ## [How to use logic operators on a date?](https://community.silverfin.com/t/how-to-use-logic-operators-on-a-date/235)
**Author:** [@GMOONS](https://community.silverfin.com/u/GMOONS)\ **Replies:** 1\ **Last updated:** [May 5, 2017, 11:16am UTC](https://community.silverfin.com/t/how-to-use-logic-operators-on-a-date/235 "2017-05-05T11:16:03Z")
Dear, I believe it is interesting to know how to use logic formula’s on a date. Suppose I want to know if February 29 is part of my accounting period. I tried to program it with the following code: ´´´ {% capture … --- ## [Table code working in document and export but not in reconciliation input](https://community.silverfin.com/t/table-code-working-in-document-and-export-but-not-in-reconciliation-input/122)
**Author:** [@GMOONS](https://community.silverfin.com/u/GMOONS)\ **Replies:** 4\ **Last updated:** [March 22, 2017, 9:35am UTC](https://community.silverfin.com/t/table-code-working-in-document-and-export-but-not-in-reconciliation-input/122 "2017-03-22T09:35:16Z")
Dear, I’ve written code below. In document modus in my file the table below the {% nic %}{% endnic %} is working properly as well as in the export modus. However in input modus in reconciliation template the table is no… --- ## [Template Rechtvaardiging opgave 325.50](https://community.silverfin.com/t/template-rechtvaardiging-opgave-325-50/78)
**Author:** [@svalais](https://community.silverfin.com/u/svalais)\ **Replies:** 10\ **Last updated:** [March 6, 2017, 3:38pm UTC](https://community.silverfin.com/t/template-rechtvaardiging-opgave-325-50/78 "2017-03-06T15:38:54Z")
I have a problem with the template for a financial year 01/04/2016 - 31/12/2017 (longer than 12 months). In the part Ogave 325.50, because the financial yar 2017 a full year is, I need an input field under the colum 01/… --- ## [If condition, text](https://community.silverfin.com/t/if-condition-text/96)
**Author:** [@marnixcoudre](https://community.silverfin.com/u/marnixcoudre)\ **Replies:** 3\ **Last updated:** [March 2, 2017, 4:50pm UTC](https://community.silverfin.com/t/if-condition-text/96 "2017-03-02T16:50:03Z")
Dear, I used the same if construction in a reconciliation as in a text. {% if a5 \> 0 and a5 != blank %} In the reconciliation does it works fine but in the text is the if function true if my input field (a5) is blank. … [Next page](https://community.silverfin.com/tag/if/229.md?match_all_tags=true&page=1&tags%5B%5D=if)