Making totals with registers

Templates
,
1

I’m trying to put a total in the first row of a table, the following rows the data needs to be put in.
But it seems like it isn’t possible, am I right?

I used following code.

{{header}}{% newline %}
|Voorafbetaling aangever||| {{ $10 | currency }}{% newline %}
||Eerste voorafbetaling|{% input custom.vooraf1.datum as:date %}|{% $10+input custom.vooraf1.bedrag as:currency %}{% newline %}
||Tweede voorafbetaling|{% input custom.vooraf2.datum as:date %}|{% $10+input custom.vooraf2.bedrag as:currency %}{% newline %}
||Derde voorafbetaling|{% input custom.vooraf3.datum as:date %}|{% $10+input custom.vooraf3.bedrag as:currency %}{% newline %}
||Vierde voorafbetaling|{% input custom.vooraf4.datum as:date %}|{% $10+input custom.vooraf4.bedrag as:currency %}{% newline %}
{% endstripnewlines %}```
2

Unfortunately this is impossible with registers, since they are read from the top to the bottom. You can solve this by doing the following:

{% assign totaal = custom.vooraf1.bedrag+custom.vooraf2.bedrag+custom.vooraf3.bedrag+custom.vooraf4.bedrag %}

{% stripnewlines %}
{{header}}{% newline %}
|Voorafbetaling aangever||| {{ totaal | currency }}{% newline %}
||Eerste voorafbetaling|{% input custom.vooraf1.datum as:date %}|{% input custom.vooraf1.bedrag as:currency %}{% newline %}
||Tweede voorafbetaling|{% input custom.vooraf2.datum as:date %}|{% input custom.vooraf2.bedrag as:currency %}{% newline %}
||Derde voorafbetaling|{% input custom.vooraf3.datum as:date %}|{% input custom.vooraf3.bedrag as:currency %}{% newline %}
||Vierde voorafbetaling|{% input custom.vooraf4.datum as:date %}|{% input custom.vooraf4.bedrag as:currency %}{% newline %}
{% endstripnewlines %}

3

Thanks @Sam.

Any idea how I can solve it with this code?
Here I made a fori loop (as I asked earlier today). In every loop, I want the total of only this loop, but I also want to make an overall total that needs to be put in the first row of the table…

{{ header }}
|Kinderopvang||| {{ $0 | currency }}

{{ header }}
{% stripnewlines %}{% fori kinderopvang in custom.kinderopvang %}
||{% input kinderopvang.naam %}|
{% newline %}
||Aantal dagen|{% $1+input kinderopvang.dagen %}||
{% newline %}
||Bedrag per dag|{% $2+input kinderopvang.bedragperdag as:currency %}||
{% newline %}
||Bedrag beperkt|{% $3+input kinderopvang.bedragbeperkt default:"11,20" as:currency %}||
{% newline %}
||Totaal aftrekbaar|{% if $2 > $3 %} {% $0+ $1*$3 as:currency %} {% else %} {% $0+ $2*$3 as:currency %}{% endif %} {{ $0 }}
{% newline %}{% endfori %}
{% endstripnewlines %}```
4

@Cedric, this is a bit more complex. You need to use a forloop for a every value you have saved. Something like this should work.

{% stripnewlines %}
{% for kinderopvang in custom.kinderopvang %}
{% assign bedrag = kinderopvang.bedragperdag %}
{% assign grens = kinderopvang.bedragbeperkt %}
{% assign dagen = kinderopvang.dagen %}
{% if bedrag > grens %}
   {% assign totaal = totaal+(dagen * grens) %}
{% else %}
    {% assign totaal = totaal+(dagen * bedrag) %}
{% endfor %}

|Kinderopvang||| {{ totaal | currency }}

{{ header }}
{% stripnewlines %}{% fori kinderopvang in custom.kinderopvang %}
||{% input kinderopvang.naam %}|
{% newline %}
||Aantal dagen|{% $1+input kinderopvang.dagen %}||
{% newline %}
||Bedrag per dag|{% $2+input kinderopvang.bedragperdag as:currency %}||
{% newline %}
||Bedrag beperkt|{% $3+input kinderopvang.bedragbeperkt default:“11,20” as:currency %}||
{% newline %}
||Totaal aftrekbaar|{% if $2 > $3 %} {% $0+ $1*$3 as:currency %} {% else %} {% $0+ $2*$3 as:currency %}{% endif %} {{ $0 }}
{% newline %}{% endfori %}
{% endstripnewlines %}

5

@Sam

Changed it like this now. The overall total is not calculated and the second total in the loop isn’t correct. I tried to solve it myself but I couldn’t find the problem.

{% stripnewlines %}
{% for kinderopvang in custom.kinderopvang %}
{% assign bedrag = kinderopvang.bedragperdag %}
{% assign grens = kinderopvang.bedragbeperkt %}
{% assign dagen = kinderopvang.dagen %}
{% if bedrag > grens %}
   {% assign totaal = totaal+(dagen * grens) %}
{% else %}
    {% assign totaal = totaal+(dagen * bedrag) %}
{% endif %}
{% endfor %}
{% endstripnewlines %}

{{ header }}
|Kinderopvang||| {{ totaal | currency }}

{{ header }}
{% stripnewlines %}{% fori kinderopvang in custom.kinderopvang %}
||{% input kinderopvang.naam %}|
{% newline %}
||Aantal dagen|{% $1+input kinderopvang.dagen %}||
{% newline %}
||Bedrag per dag|{% $2+input kinderopvang.bedragperdag as:currency %}||
{% newline %}
||Bedrag beperkt|{% $3+input kinderopvang.bedragbeperkt default:“11,20” as:currency %}||
{% newline %}
||Totaal aftrekbaar|{% if $2 > $3 %} {% $0+ $1*$3 as:currency %} {% else %} {% $0+ $1*$3 as:currency %}{% endif %} {{ $0 }}
{% newline %}{% endfori %}
{% endstripnewlines %}```

 ![image|690x234](upload://5CFxlmZq95Uo7OwwqGH9Nu2rwAU.png)
6

Did something wrong with the picture, hereby

image
image.png951×323 6.29 KB

7

{% if bedrag > grens %}
{% assign totaal = totaal+(dagen * grens) %}
{% else %}
{% assign totaal = totaal+(dagen * bedrag) %}
{% endif %}

remove the spaces beteween dagen and grens and the spaces between dagen and bedrag

8

Great!

And how can I solve the part of the total of every loop? Next to “Totaal aftrekbaar”?

{% stripnewlines %}{% fori kinderopvang in custom.kinderopvang %}
||{% input kinderopvang.naam %}|
{% newline %}
||Aantal dagen|{% $1+input kinderopvang.dagen %}||
{% newline %}
||Bedrag per dag|{% $2+input kinderopvang.bedragperdag as:currency %}||
{% newline %}
||Bedrag beperkt|{% $3+input kinderopvang.bedragbeperkt default:“11,20” as:currency %}||
{% newline %}
||Totaal aftrekbaar|{% if $2 > $3 %} {% $0+ $1*$3 as:currency %} {% else %} {% $0+ $1*$2 as:currency %}{% endif %} {{ $0 }} {% assign $0 = 0 %}
{% newline %}{% endfori %}
{% endstripnewlines %}{% endifi %}```
9

You need to reset all of your registers (like you did with $0).

10

Hehe, should’ve seen it. :drooling_face:
Thanks.