Complex Logic Example 1: CashTx

The first row specifies that any accounts that begin with “11” are included in the calculated result for “Calc Item: CashTx.”

The second row further qualifies the results by specifying that the source record must also have the entity like “TX.”

The third line reduces the results to only those source records that have an ICP value between 00 and 09.

The last line reduces the results to only those source records that have a Custom 1 (UD1) of either: 00, 01 or 02. Imported lines that do not meet the listed criteria are excluded from the calculated results.

In the following table, only one new logic item is derived from multiple source records. Using the preceding graphic example as the logic criteria, and the first grid that follows as the source line items, you can see how FDMEE derives the value of a single logic item. Note the Group By field. Each Group By field includes a hard-coded value. Therefore, for every line that passes the specified criteria, the original imported member is replaced with the member listed in the Group By field.