Within Outlaw, calculated variables can be used to perform basic math functions between individual connected (Filevine) and non-connected variables.
đź’ˇ These variables will be marked as Read Only within actual document generation (Flow). If any updates need to be made to the calculation, they must be made at the template level.
Creating a Calculated Variable:
- To start a calculated variable, begin with
[%
and then the name of your variable, finishing with the closed bracket]
. - Your calculated variable will appear red until a formula is provided. Click your variable and begin typing out your formula.
Desired Function |
Symbol |
Multiplication |
* |
Division |
/ |
Addition |
+ |
Subtraction |
- |
Grouping of Variables |
{ ) |
Note: You will only be able to include existing currency, number, or percentage variables within your formula. Text, Image, Table variables, etc. will not work within the calculations.
Calculated variables can have their decimal point specified in the relevant pull-down option.
Calculated Variables within a Calculated Variable:
While building your template, remember that you can include calculated variables as individual parts of another calculated variable.
For example, if you wanted to take the outcome of the [%TestVariable]
and multiply that either by another calculated variable or standard Outlaw variable--you can!
Utilizing Filevine Connected Variables within Calculated Variables
Filevine users have the option to utilize connected variables within their calculated variables as well.
As with other calculated variables, you are limited to currency, number, percentage, and other calculated fields that exist in Filevine. Your connected variables must exist in your template before adding them to the calculated variable formula.
For example, let's say we are looking to multiply our projected settlement amount for our case and the attorney's fee percentage for the case.
- First, ensure that these two fields are brought into our template. Start with the
[+fv_
and find your desired fields in the dropdown to bring them into your template. - Next, begin the Calculated variable using the
[%
, naming the variable, and then completing with the]
. - As shown above, you will now want to enter your formula for this connected variable.
Calculated Columns
Within Outlaw and FVDA tables, calculated columns can be enabled to perform basic math functions between numerical values within the document or within the table itself. Calculated columns allow tables to be used for invoice-like situations where adjustments like reductions or fees, or net amounts may need to be shown on a row-by-row basis.
Configuring a Calculated Column
- To enable a calculated column, click on the relevant table variable and select Configure.
- Select the column where you want to do calculations, and enable the “Calculated column” setting.
- In the Formula field, begin typing your formula. To reference values from within the same table, use the
{
indicator, and column names will be auto-suggested if their values are numerical.
Error Messages
When utilizing Calculated variables, you may see certain error messages on the variables due to the below reasons.
Error Message |
Meaning |
#DIV0! |
Your calculated variable is trying to divide by zero |
#ERROR! |
Invalid formula |
#NAME! |
There is an invalid or not found variable within the formula |
#REF! |
The Connected variable has a formula referencing itself or multiple vars referencing each other. |
Comments
0 comments
Article is closed for comments.