Skip to main content Skip to complementary content
Announcements

Add functions

Procedure

  1. Click the Total_Price element under the AC_Record element on the Output side to select it.
  2. 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.
  3. 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.
  4. 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.
  5. Click the Type element under the AB_Record element on the Output side to select it.
  6. 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.
  7. 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.
  8. Click the Type element under the AC_Record element on the Output side to select it.
  9. 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.
  10. 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.
  11. Click the Type element under the AZ_Record element on the Output side to select it.
  12. 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.
  13. 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.
  14. Click the Total_Value element under the AZ_Record element on the Output side to select it.
  15. 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.
  16. Expand the Arithmetic folder, and then drag the Multiply function and drop it on the AgSum function.
  17. Click the AC_Record element on the Output side to select it.
  18. On the Loop tab, right click SimpleLoop and then click Copy.
  19. 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.
  20. 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.
  21. 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.
  22. Press CTRL+S to save your changes.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here