Using Computation Rules to Automate the System


This article assumes that you have read and understand the material covered in  Using Conditional Statements.

In LoanPro, there are several automated evaluation channels that can change the stoplight or flag status for your loan. These status changes are evaluated when a loan is updated on a daily basis, generally outside of business hours for the US and Canada, and can be run manually from inside of a loan as needed. This article will primarily cover how to create these computation rule systems.

Basics of Rules for Stoplights and Flags

Up until now, almost all of the rules you made could return just about any kind of data, whether it be a number, a date, text, or true/false. This is because the computation rule(s) that you made just displayed the value to you and LoanPro didn’t use the value directly for interacting with your loans. However, this is no longer the case. Your computation rules become only a single part of a larger expression in LoanPro, and as a result LoanPro expects them to return a specific set of values otherwise, it won’t work.

For Stoplight and Flags, your computation rule(s) must return either true or false; any other value that your rule evaluates to will not be understood by LoanPro or will result in behavior that you didn’t intend.

Tip: As a general rule of thumb, always test your rule(s) through a  computation field before adding it to a flag or stoplight rule. This helps speed up the process of developing and testing a rule since you won’t have to wait until the next day to see if the rule did what you wanted it to.

The reason for this is that your rule(s) are the conditional expression in an IF statement generated by LoanPro. This expression looks similar to the following:

(if {your computation rule} {perform desired stoplight/flag change})

This means that the rule you provide is used to determine whether or not the system is to perform the desired changes to the flag or stoplight. Keep this in mind as you create your stoplight and flag rules since it can determine if the system performs how you expect it to or not.

Creating a Stoplight Rule

To create a  stoplight rule, navigate to Settings > Loan > Alerts > Stoplight and then click  in the upper right corner as shown in Fig 1.

Fig 1. Add a Stoplight Navigation

A page similar to Fig 2 should then appear. At the bottom is the formula editor where you put your formula (remember, it needs to evaluate to true or false). Above that is a red, yellow, and a green circle. Here you choose the color you want to have a loan’s stoplight to be if your condition is true. Just click on the color you want it to be.

Additionally, there is an Active/Inactive toggle below the Save button. If a stoplight rule is inactive then the system will ignore it otherwise, the system will test it against all loans to see if a loan matches the condition.

When you are done, click Save.

Please note that each loan can only have one stoplight value set at a time. As a result, each stoplight has a priority which determines which stoplight rule is evaluated first, which one second, and so forth. LoanPro will stop evaluating once it finds the first active rule that a loan matches.

This means that when a loan’s stoplight status is being evaluated, LoanPro will check to see if the first rule works; if not then it will do the second, and then if that rule doesn’t work it will check the third rule and so forth until it finds the first rule that works. That means if a loan matches the first rule the system will ignore all other rules for that loan and will move on to the next loan, even if you have other rules that would’ve matched for that loan.

Keep this in mind as you create your rules.

Creating a Flag Rule

To create a flag rule, navigate to Settings > Loan > Alerts > Flag System and then click  in the upper right corner as shown below.

Creating a Flag Navigation

There are Four fields of interest when creating a flag: The flag’s name, it’s color, it’s description, and the computation rule/formula for it.

The Flag name is placed in the TextBox labeled “Name”. Enter the name that you want this flag to be known by. Next is the flag’s color which is the drop-down box next to the name; go ahead and select the box and then choose the color that you want the flag to be.

Next is the Flag Description. This is the text that you want to be displayed whenever someone views the flag’s details. This can optionally have information about the loan with the flag.  To insert this information click on the “Help Variables” text just above the description box and then select the desired variables much in the same way as you would with a computation rule. The main thing here is that the variables are formatted differently for the description than for the rules since the system needs help to know when you want the loan-amount and when you want to display “loan-amount”.

Finally, enter the  computation rule that determines when the flag status will change.

When you’re done, click Save.

As you’ve probably noticed, there is no priority category for flags, unlike Stoplights. This is because the same loan can have multiple flags, so LoanPro evaluates every loan against all of the flags to see which one(s) match. This means that if there are two flag rules that a loan matches, then there will be two flags for that loan. 

How did we do?

Powered by HelpDocs (opens in a new tab)