# Catch-up on Rules Engine Enhancements

- Last updated

- Save as PDF

### September 2020: 6.17 Release

N/A

### July 2020: 6.16 Release

Rules Engine is designed to improve your underlying customer data to produce superior customer outcomes. It can perform powerful multi-step, in-memory data transformations for large datasets in Gainsight within one rule. Transformations include aggregations, multi-dataset merges, formulas and time-series calculations; helping your team to better identify meaningful data signals.

#### Improved Rules Engine Formula Functions

Gainsight introduces new Number Formulas to the Formula Fields in Rules Engine. These enable you to perform powerful calculations in your Transformation Tasks while setting up a rule.

The following number formulas are available:

: The Abs formula returns the absolute value of a number. You can provide your input in the formula field as a positive or negative integer, but the output is always a 7.3890561positive integer. For more information on using the Abs formula, refer to the**Abs**article.*ABS function*: The Ceiling formula maps a number to the least integer greater than or equal to the number. For more information on using the Ceiling formula, refer to the**Ceiling**article.*Ceiling function*: The Exp formula returns Euler's number, e (~2.718) raised to a power.**Exp**

Example: EXP(1) = Approximate value of e = 2.71828183

EXP(2) = Base of the natural logarithm e raised to the power of 2 = 7.3890561: The Floor formula maps a number to the greatest integer less than or equal to the number. For more information on using the Floor formula, refer to the**Floor**article.*Floor Function*: The Log formula returns the logarithm of a number given a base. For more information on using the Log formula, refer to the**Log**article.*Log Function*: The Sqrt formula returns the positive square root of a positive number.**Sqrt**: The ln formula returns the natural logarithm of a number, base e (Euler's number).**In**

For more information on using the ln formula, refer to thearticle.*LN function*

** Note**: For Sqrt, Log, and ln formulas require positive integers as input values. However, the rule runs successfully and no error message is thrown for negative input.

If you enter negative values, these formulas return the following values:

Formula |
Value |
---|---|

Sqrt | zero |

In | zero |

Log | null |

#### Fields in Rules Add/Subtract Date Formula Fields

The Add/Subtract Date Formula field in the Date Formulas of Transformation Tasks now accepts dynamic fields. Previously, this field accepted only static numeric values as input. With this enhancement, the number of days you add to or subtract from a date dynamically changes with the value of the selected field.

**Note**: You can select the unit of the field as **Days **only. The **Weeks **option is not available.

For more information on the usage of Date Formulas, refer to the *Formula Fields in Bionic Rules* article.

### June 2020: 6.15 Release

N/A

### May 2020: 6.14 Release

Rules Engine is designed to improve your underlying customer data to produce superior customer outcomes. It can perform powerful multi-step, in-memory data transformations for large datasets in Gainsight within one rule. Transformations include aggregations, multi-dataset merges, formulas and time-series calculations; helping your team to better identify meaningful data signals.

#### Load to PX Actions

With the new **Load to PX** Action type, admins can now push data to Gainsight PX entities using the Rules Engine in Gainsight CS. PX has two entities, an Account entity and a User entity. With the Load to PX** **Action, CS administrators can build Rules to load values into custom attributes of the PX Account and User entities. This makes the CS - PX integration a bidirectional data sync combined with the PX connector.

**IMPORTANT: To start using the Load to PX Action type from the Actions drop down menu, contact Gainsight Support to get this Action Type enabled for you.**

**Parent Account ID **in PX: The Account entity in PX now has a new custom attribute called Parent Account ID that can track the different values of the parent account. With this attribute, you can group different PX accounts that map to the same Company object in CS.

**Business Use Cases**

- With Load to PX Action, you can push CS health scores into PX. This allows you to filter PX reports by health score and helps you to target PX Engagements differently for Red vs Green accounts.
- You can sync the Company Stage attribute to PX from CS, which helps you distinguish, for example, if customer Accounts are in the Onboarding stage or in the Adopting stage. This is very useful for interpreting usage data in PX and target PX Engagements in different stages.
- You can use the calculation capabilities in CS to add value to PX. PX is optimized for fast on-the-fly queries whereas the Rules Engine is a batch processing tool that can handle hugely complicated data processing and calculations. One way to manifest this capability is to use the Rules Engine to periodically put PX Users into various categories. For example, you could define a 'premium user' as someone who has exceeded a threshold of activity in your product in at least four of the previous six months.
- CS has access to useful data like support cases. You could define a 'negative support user' as someone who filed a critical case that has been open for more than a week. Using Load to PX Action to mark these users in PX can help with both interpreting usage data and guiding users with PX Engagements.

For detailed information on how to configure the Action type, refer to the *Load to PX Action Type* article.