Overview
Calculated fields in Baseline allow you to define custom formulas that automate computations for loan data. These formulas can be configured at two levels:
Product Level: Applies to all loans created under a specific product.
Loan Level: Allows customization for specific loans to override or refine product-level formulas.
This flexibility ensures accurate, tailored calculations for your loan workflows.
⚠️ Calculated fields are now available specifically for fields that are Number, Decimal and Percentages. Inside Loans and Products
💡 Calculated Fields can be utilized within the following tabs on each loan or product:
General Tab
Charges
Collateral Tab
Loan Settings.
How to Configure Calculated Fields
1. Product-Level Calculated Fields
Access Products:
Navigate to the top-left menu and click Products.
Select the loan product you wish to customize (e.g., "Bridge Loan Rehab").
Add or Edit Fields:
In the product editor, locate the list of fields. Fields with formulas will display the "FX" icon.
Click Add Field to create a new calculated field, or select an existing field to modify it.
Define the Formula:
In the Default Value section, type an equal sign (
=) to start creating a formula.Use the field search (by clicking the tag icon) to select fields. For example:
To calculate a Holdback-to-Loan Amount Ratio, define:
Holdback to Loan = {{Holdback}} ÷ {{Loan Amount}}
Choose the field type (e.g., percentage, currency).
Save Changes:
Click Save to apply the formula. The calculated field will now apply to all loans created using this product.
For this example, the Loan Amount is $150,000 and the Holdback is 50,000
⚠️ The calculation result will be visible only when the fields used contain values.
2. Loan-Level Calculated Fields
Access the Loan:
Navigate to the specific loan you want to customize.
Edit Fields:
Locate the field you want to customize or create a new one.
Modify the Formula:
Adjust the formula based on the loan's specific requirements. For example:
Add a fixed value to the Holdback in the formula:
Holdback to Loan = ({{Holdback}} + 15000 )÷ {{Loan Amount}}
Save Changes:
Click Save. The custom formula will now override the product-level formula for this loan.
Argument Structure
Each formula follows the standard Excel syntax:
General Formula Structure:
FUNCTION_NAME(argument1, argument2, ...)
Separators:
Use commas (
,) to separate arguments.
Logical Operators:
Use
>,<,=, etc., for conditions in functions likeIF,AND,OR
We encourage you to take a look at the formulas we support:
https://help.baselinesoftware.com/en/articles/10223921-supported-formulas-and-argument-structures