Abs

Outputs a number into an absolute value.

{{ -23 | abs }}

This filter can also be applied with the following syntax.

{{ ABS(-23) }}
Output
23

Ceil

Allows to round the input UP. For example, the nearest whole number of 1.2 is 1, however, if you use ceil:0 filter, it will round UP the value and the result will be 2.

🚧

Ceil filter needs to be used with precision for it to work.

Depending on the number used with ceil, the value can be rounded UP in a different way, for example:
ceil:0 is to the nearest whole number
ceil:1 is to the nearest 0.1
ceil:2 is to the nearest 0.01
ceil:-1 is to the nearest 10

Ceil 0: {{ 1.2222 |ceil:0 }}

Ceil 1: {{ 1.2222 |ceil:1 }}

Ceil 2: {{ 1.2222 |ceil:2 }}

Ceil -1: {{ 1.2222 |ceil:-1 }}
Output

Floor

Similar to ceil, this allows to round the input DOWN. For example, the nearest whole number of 1.8 is 2, however, if you use floor:0 filter, it will round DOWN the value and the result will be 1.

🚧

Floor filter needs to be used with precision for it to work.

Depending on the number used with floor, the value can be rounded DOWN in a different way, for example:
floor:0 is to the nearest whole number
floor:1 is to the nearest 0.1
floor:2 is to the nearest 0.01
floor:-1 is to the nearest 10

Floor 0: {{ 17.8888 | floor:0 }}

Floor 1: {{ 17.8888 | floor:1 }}

Floor 2: {{ 17.8888 | floor:2 }}

Floor -1: {{ 17.8888 | floor:-1 }}
Output

Currency

This will output a value into the currency format, depending on the chosen language in Silverfin. This is a filter made by Silverfin.

🚧

"#61" will give the value of all 61-accounts for the selected period.

{{ #61 | currency }}
Output
121,590.31

Invert

Invert how the value of accounts are displayed based on their type.

This filter will only work together with the 'currency' filter

Currency

Credit: {{ accounts_c | currency:0 }}
Debit: {{ accounts_d | currency:0 }}

Currency - Invert

Credit: {{ accounts_c | currency:0, invert:true }}
Debit: {{ accounts_d | currency:0, invert:true }}
Output

Integer

This will output a value without decimals.

❗️

Please note that an integer returns a formatted string, not an actual number. This behaviour can be misleading when making calculations because of the commas and dots.

{{ 30.99 |integer }}
Output
31

Using as an integer in the following syntax will give you a different output.

{{ INT(30.99) }}
Output
30

Percentage

This will output a value as a percentage.

📘

The formula (#60+#70)/#70 is the calculation of gross margin, where the 60-accounts are in plus and the 70-accounts in minus.

{{ (#60+#70)/#70 | percentage }}
Output
99.89%

Number_to_human

This will output the value of [linkto account drop]accounts[endlinkto] into a combination of a rounded number and English word for that rounded number, if it's more than 1 thousand. This is a filter made by Silverfin.

{{ #6 | number_to_human }}
Output
287 Thousand

Number_to_currency

This will output a string to the currency format, depending on the language setting of Silverfin. This filter is made by Silverfin.

{{ "123456789.99" | number_to_currency }}
Output
123.456.789,99

Round

This will output a value to a rounded value, depending on a number that can be given as an argument. As a default, you will see two decimals after the coma.

Example 1 with two decimals: {{ #6 | round }}

Example 2 with zero decimals: {{ #6 | round:0 }}
Output

Example 1 with two decimals: 313734.14

Example 2 with zero decimals: 313734.0

Modulo

Divides an output by a number and returns the remainder.

{{ 9 | modulo:2 }}
Output
1

MAX & MIN

MAX and MIN are used to return the maximum or minimum value in a collection of data.

MAX: {{ MAX(30;40;50;60;70) }}
MIN: {{ MIN(30;40;50;60;70) }}
Output
MAX: 70
MIN: 30