AggregateFunction
The AggregateFunction Math variable provides a method for manipulation of an array. The method is defined in the Math variable properties.
AggregateFunction Math Variable in Palette
Note: For a comprehensive explanation of the characteristics of this math variable, refer to the XML Configuration Guide in the Help menu.
Define the AggregateFunction Math Variable
Drag and drop the AggregateFunction math variable from the Palette window onto the Math Pane. Enter the following information for the math variable.
-
Type a name in the Name field. This is required.
-
Make sure variable type is defined AggregateFunction. This is required.
- Select the appropriate DataType from the drop down selection box. DataType is required. The applicable data types are: Activity, Boolean, Date, Decimal, Integer, Map, Object, and Text.
-
Select Yes or No from Log field. Default is No. This is an optional field.
- Round offers the options of Yes or No. Round is only enabled if you select Decimal in the data type property. If you would like to round the Decimal, select Yes. Enter the number of decimal places to Round the result value. Note: When the data type of Decimal is selected, then the default value for Round is set to No. You must change the selection of the radio button to Yes if you wish to round.
- Select the appropriate Method. Method is a required property. The options for Method are as follows:
- Count: Returns the number of elements in the array.
- Index: Returns the value of the specific number element. Indexing allows the system to identify the value by the elements location, we can then use the value for storage, a subsequent calculation, or display purposes.
- Max: Returns the highest element value.
- Min: Returns the lowest element value.
- Sum: Returns the total value/sum of all elements.
Check-in the transaction to save the information to the database.
Copyright © 2009, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices