Field
The Field math variable allows for an activity, policy, plan, or valuation value to be retrieved and used in subsequent Math calculations. The field must be defined first within the activity, plan screen, policy screen, or valuation prior to using it within the Math.
Field 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 Field Math Variable
Drag and drop the Field 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. Note: The name of Math variable for a Field you wish to use as defined in the activity must have a different naming convention in the Math. For example, if the name of the Field in the activity is IssueDate and you wish to pull IssueDate in to the math for further manipulation, you must name the Math variable some other than IssueDate. You may use MV at the end of the Math variable name to indicate Math Variable, IssueDateMV.
-
The data types are Activity, BigText, Boolean, Date, Decimal, Integer, Map, Object, and Text. This is required.
-
Make sure variable type is defined as Field. This is required.
-
Select Yes or No from the Log field. The default is No. This is an optional field.
- Round offers the options of Yes or No. Round is only enabled if you select the 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, 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.
-
Default is used for a Decimal or Integer value so the system will not return a null value. For example, the default for an Integer data type could be -999999999.
- Type in the following for the Prefix: Activity:, Plan:, Policy:, or Valuation:.
- The Value is the name of the Field you wish to retrieve. Type in the Name of the field.
Check-in the transaction to save the information to the database.
Copyright © 2009, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices