Makes a calculation with the data of the collection order and stores the result in a variable, which you use later in the workflow (for example in Logic or Add costs). You can calculate with numbers and with dates.
Ports
| Port | Meaning |
|---|---|
| in | Input |
| out | Fires after the result is stored |
Settings
| Setting | Required | Explanation |
|---|---|---|
| Calculation | Yes | The expression, for example bedrag * 0.15 or dagen(vandaag, vervaldatum) |
| Target variable | Yes | The variable of the collection order that gets the result |
Operators: +, -, *, /, % (remainder), ** (power) and brackets.
Functions (a selection): round, minimum, maximum, average, median, days between two dates, date plus x days. The available functions are listed in the editor; when you save, the expression is checked for errors and unknown variables.
Examples
| Goal | Expression | Target variable |
|---|---|---|
| Calculate collection costs of 15% | bedrag * 0.15 |
kosten |
| Days past the due date | dagen(vervaldatum, vandaag) |
dagen_te_laat |
| Payment term until the first of next month | dagen(vandaag, eerste_volgende_maand) |
termijn |
| Number of rent terms in arrears | afronden(bedrag / variabele35, 1) |
termijnen_achter |
Good to know
- An unusable value (empty variable, text instead of a number, dividing by zero) puts the collection order on Error and creates a task.
- Use the result right away in a Logic node to branch, or in Add costs as the amount.
- You can do a lot of custom work from import scripts with Calculate in the workflow itself, so you stay in control of it yourself.