DigiFi's formula language is powerful tool that lets you write complex calculations using simple syntax and Excel-like functions. It is used through the DigiFi platform for a number of purposes, including:
- Calculation modules within decision strategies.
- Calculated variables within loan products.
- Display conditions in the lender application views, borrower profile, intermediary profile and application form.
- Status rules in workflow statuses.
- ... and more!
In general, formulas in DigiFi are simple functions that look comparable to spreadsheet functions, for example in Microsoft Excel or Google Sheets. They can include mathematical operators and built-in functions, and can reference variables (i.e. data fields) within the calculations.
DigiFi's formula language consists of few basic lexical constructions, including:
You can access variables within formulas by using their system name.
borrower_first_name + borrower_last_name
Divide And Floor
Greater than or equal
Less than or equal
Conditional expressions check to see if the first segment evaluates to a truthy value. If so, the consequent segment is evaluated. Otherwise, the alternate is. If the consequent section is missing, the test result itself will be used instead.
You can use many Excel-like functions within DigiFi formulas. For example:
Logical AND function
Lower Case Function
You can find full list of the functions here: