Docupilot
Ask or search…
K
Links
Comment on page

Numerical Calculations

Want to calculate the numerical value for a field based on merge tokens? You can do so by entering your mathematical equation in the format below.
Operation
Syntax with two variables
Syntax with a variable & constant
Addition
{{add x y}}
{{add x 10}}
Subtraction
{{subtract x y}}
{{subtract x 10}}
Multiply
{{multiply x y}}
{{multiply x 10}}
Divide
{{divide x y}}
{{divide x 10}}
Modulo
{{modulo x y}}
{{modulo x 10}}
Rounding of numbers
{{ceil x}} / {{floor x}} / {{round x}}

Numerical Calculation in Loops & Tables

You can also use Numerical Calculation in Loops & Tables.
Example
{{#each line_items}}
Name: {{Name}}
Qty: {{Qty}}
Price: {{Price}}
Total: {{multiply Qty Price}}
{{/each}}

Incrementing @index in Loops & Tables

If you want to display the index of an element while iterating the loop, you can use {{@index}}. It usually starts from 0, so everytime you will have to increment it with 1. You can use add operator with @index.
Example
{{#each line_items}}
Sno: {{add @index 1}}
Name: {{Name}}
Qty: {{Qty}}
Price: {{Price}}
Total: {{multiply Qty Price}}
{{/each}}

Rounding of numbers

Rounding of the numbers can be done using the helpers ceil, floor, and round.

Ceil

The helper ceil will round off the number to the nearest positive number which is greater than or equal to the give input number.
Example syntax
Input
Output
{{ceil number}}
198.58
199
{{ceil input}}
187.24
188

Floor

The helper floor will round off the number to the nearest positive number which is lesser than or equal to the given input number.
Example syntax
Input
Output
{{floor number}}
198.58
198
{{floor input}}
187.24
187

Round

Round helper will round of the given number in accordance with the value in it's decimal place. If the value in decimal places is greater than 50, then it will round of to the succeding number.
Example syntax
Input
Output
{{round number}}
198.58
199
{{round input}}
-187.74
-188