.jpg)
The first row specifies that source-record Account members must begin with 11. The second row specifies that the source-record Entity member must be Tx. The third row specifies that source-record ICP members must be between 00 and 99. The last row specifies that source-record UD1 (Custom1) members must be 00, 01 or 02. Imported source records that do not meet all of the listed criteria are excluded from the calculated results.
As illustrated in the following tables, for Example 1, FDM derives one logic account from multiple source records. The first table lists examples of member combinations and, applying the logic criteria of the current example, identifies combinations (and thus data values) as included or excluded. The second table identifies the member combinations that are included—with the original member names replaced by the hard-coded values that are defined in the Group By field. The third table illustrates the final result.