Add functions
Procedure
- Click the Total_Price element under the AC_Record element on the Output side to select it.
- In the Functions view on the left, expand the Arithmetic folder, and then drag the Multiply function and drop it onto the Value tab of the Total_Price element.
- Drag the Quantity element from under the C_Record element on the Input side and drop it into First Value - Drop/paste in the Multiply function on the Value tab.
- Drag the Unit_Price element from under the D_Record element on the Input side and drop it into Second Value - Drop/paste in the Multiply function on the Value tab, and then click Yes when asked if you want to change the output map element looping.
- Click the Type element under the AB_Record element on the Output side to select it.
- In the Functions view, expand the General folder, and then drag the Constant function and drop it onto the Value tab of the Type element.
- Double-click the Constant function in the Value tab, enter AB in the Value field of the Expression Constant Properties dialog box that opens, and then click OK.
- Click the Type element under the AC_Record element on the Output side to select it.
- In the Functions view, expand the General folder, and then drag the Constant function and drop it onto the Value tab of the Type element.
- Double-click the Constant function in the Value tab, enter AC in the Value field of the Expression Constant Properties dialog box that opens, and then click OK.
- Click the Type element under the AZ_Record element on the Output side to select it.
- In the Functions view, expand the General folder, and then drag the Constant function and drop it onto the Value tab of the Type element.
- Double-click the Constant function in the Value tab, enter AZ in the Value field of the Expression Constant Properties dialog box that opens, and then click OK.
- Click the Total_Value element under the AZ_Record element on the Output side to select it.
- In the Functions view, expand the Aggregate folder, and then drag the AgSum function and drop it onto the Value tab of the Total_Value element.
- Expand the Arithmetic folder, and then drag the Multiply function and drop it on the AgSum function.
- Click the AC_Record element on the Output side to select it.
- On the Loop tab, right click SimpleLoop and then click Copy.
- Return to the Total_Value element under the AZ_Record on the Output side and, on the Value tab, under the Multiply function, right-click Loop Expression - Drop/paste here, and then click Paste.
- Drag the Quantity element under the C_Record element on the Input side and drop it onto First Value - Drop/paste here, under the Multiply function on the Value tab.
- Drag the Unit_Price element under the D_Record element on the Input side and drop it onto Second Value - Drop/paste here, under the Multiply function on the Value tab.
- Press CTRL+S to save your changes.