In this article, we will discuss about the different types of operations and its features involved in Encompass 360 Loan custom field calculation. This is in continuation to our previous article “Encompass 360 Loan Custom Field Calculations – Part 1”.
To help you understand in a simpler way, please refer the below tables to know the Loan custom field calculations involved in each of the various operations.
Safe Operations:
Function | Description | Example |
Sum(x, y, z, …) | Adds the specified values. If any operand cannot be converted to a number, the entire expression returns an empty value. | Sum([1109], [44]) |
SumAny(x, y, z, …) | Adds the specified values, ignoring those that cannot be converted to numbers. If none of the values can be converted to a number, the function returns a blank value. | SumAny([1109], [44]) |
Diff(x, y) | Evaluates to x – y if both values are numeric. If either value is non-numeric, the function returns a blank value. | Diff([1109], [44]) |
Mult(x, y, z, …) | Returns the product of the operands. If any of the operands cannot be converted to a number, the function returns a blank value. | Mult([1109], [44]) |
MultAny(x, y, z, …) | Returns the product of all operands which can be converted to numbers. If none of the values can be converted to a number, returns a blank value. | MultAny([1109], [44]) |
Div(x,y) | Returns the value of x / y if both operands can be converted to numeric values. Otherwise, returns a blank value. | Div([1109], [44]) |
Example:
0.02 * ([1109] + [44])
Rewritten using the safe operators:
Mult(0.02, Sum([1109], [44]))
Mathematic Operations:
Function | Description | Example |
Abs(x) | Returns the absolute value of the specified argument. | Abs([101] – [102]) |
Min(x, y, z, …) | Returns the smallest of a set of values. | Min([102], [103], [104]) |
Max(x, y, z, …) | Returns the largest of a set of values. | Max([102], [103], [104]) |
LMedian(x, y, z, …) | Returns the median value of a set of numbers. If an even number of values is specified, the lower of the two middle values will be returned. | LMedian([#67], [#1450], [#1414]) |
UMedian(x, y, z, …) | Returns the median value of a set of numbers. If an even number of values is specified, the higher of the two middle values will be returned. | UMedian([#67], [#1450], [#1414]) |
Sqrt(x) | Returns the square root of a value. | Sqrt(0.02 * [1109]) |
Log(x) | Returns the natural logarithm (base-e) of the value. | Log(1000 + [910]) |
Log10(x) | Returns the base-10 logarithm of the value. | Log10(1000 + [910]) |
Exp(x) | Returns the value of ex. | Exp([1171] / 100) |
Pow(x, y) | Returns the value of xy. | Pow([1171], 5) |
Sgn(x) | Returns 1 if x > 0, 0 if x = 0, or -1 if x < 0. | Sgn([1093]) |
Round(x, precision) | Rounds the value x to a number of decimal places specified by precision. | Round([1109], 2) |
Trunc(x, precision) | Truncates the value x to a number of decimal places specified by precision. | Trunc([1109], 2) |
XInt(x, default) | Converts the value x to an integer. If x is a string, the integer value it represents is returned. Non-integral values are rounded to the nearest integer. If the value cannot be converted successfully, the optional default value is returned. If no default is provided, the value 0 is returned. | XInt(“230”) or XInt([1109], 1) |
XDec(x, default) | Converts the value x to a decimal. If x is a string, the numeric value it represents is returned. If the value cannot be converted successfully, the optional default value is returned. If no default is provided, the value 0 is returned. | XDec(“245.112”) or XDec([1109], -1) |
Text-Based Operations:
Function | Description | Example |
Trim(x) | Removes any white space characters from the beginning and end of the value x. | Trim([4000] & ” ” & [4002]) |
Left(x, n) | Returns the left-most n characters from the value x. If x is shorter than n characters, the whole value is returned. | Left([4002], 5) |
Right(x, n) | Returns the right-most n characters from the value x. If x is shorter than n characters, the whole value is returned. | Right([4002], 5) |
Mid(x, start, length) | Returns the substring of the value x that starts at the specified locations and has the specified length. If length is omitted, the entire string after start is returned. The start position is 0-based. | Mid([4002], 3, 2) |
InStr(x, y) | Returns the first position of the substring y within the string x. The comparison is case-sensitive. | InStr([4002], “mith”) |
Int2Text(x) | Converts an integer value to its spelled out representation, e.g. “Five Hundred Thirty-Four.” | Int2Text([4]) |
Dec2Text(x) | Converts a decimal value to its spelled out representation, e.g. “Sixty-Five and Fifty-Three Hundredths.” | Dec2Text([3]) |
Money2Text(x) | Converts a decimal value to its spelled out representation using ‘dollars’ and ‘cents’ notation, e.g. “Sixty-Five Dollars and Fifty-ThreeCents.” | Money2Text([1109]) |
LCase(x) | Returns the value of x with all letters converted to lower case. | LCase([4002]) |
UCase(x) | Returns the value of x with all letters converted to upper case. | UCase([4002]) |
Replace(x, y, z) | Replaces all instances of the substring y within the string x with the replacement value z, and returns the resulting string. | Replace([1264], “Investor”, “Lender”) |
The other operators are explained in our next article, please refer below link:
Encompass 360 Loan Custom Field Calculations – Part 3
Looking for more information on integrating Encompass 360 with Velocify or need help in integrating right technology, leave us a message.
Take Five Consulting is a technology company, based in Virginia U.S., that specializes in the Mortgage Banking vertical especially LOS implementation and application development. Take Five Consulting creates and implement mortgage technology and software specifically for Mortgage Industry.