Supported Formulas
📖 For a complete guide on setting up and using calculated fields, including how to implement these formulas, refer to Calculated Fields in Baseline.
Arithmetic and Mathematical Functions
Basic Math Functions
+, - , * , / , ^Use
()to add calculation orderFLOOR(number): Rounds a number down to the nearest integer.ABS(number): Returns the absolute value of a number.SQRT(number): Returns the square root of a number.EXP(number): Returnseraised to the power of a given number.LN(number): Returns the natural logarithm of a number.ROUND(number, num_digits): Rounds a number to the specified number of digits.CEILING(number, significance): Rounds a number up to the nearest multiple of the specified significance.Example:
CEILING(12.34, 0.5) → 12.5
Date and Time Functions
TODAY(): Returns the current date.DAY(date): Extracts the day from a date.MONTH(date): Extracts the month from a date.YEAR(date): Extracts the year from a date.DATEDIF(start_date, end_date, unit): Returns the difference between two dates.Units:
"D"(days),"M"(months),"Y"(years).
EOMONTH(start_date, number of months): Returns the last day of the month, the specified number of months before or after the given start date.
Logical Functions
IF(condition, value_if_true, value_if_false): Returns one value if a condition is true
Example:IF(Loan Amount > 100,000, 20, "Low")AND(condition1, condition2, ...): Returns TRUE if all conditions are true.OR(condition1, condition2, ...): Returns TRUE if at least one condition is true.IFERROR(expression, value_if_error):Returns the result of an expression, or a specified value if the expression causes an error.
Text Functions
LEFT(text, num_chars):Returns the specified number of characters from the beginning (left side) of the text.RIGHT(text, num_chars):Returns the specified number of characters from the end (right side) of the text.LEN(text):Returns the total number of characters in the text, including spaces.TRIM(text):Removes all extra spaces from the text, leaving only single spaces between words.CONCATENATE(text1, text2, ...):Joins multiple text strings into one.
Please Note: In Baseline's calculated fields, IF logic uses a single equals sign (=) for comparisons - not the standard double equals common in many programming language (==).
Using == will silently fail without error. For example, use IF(Lien_Position = "First", value_if_true, value_if_false) instead of IF(Lien_Position == "First", value_if_true, value_if_false).