Function
The Function math variable calls a pre-defined system function and returns a single value. The functions allow for manipulation of values for all data types. The Function math variable is commonly used for the manipulation of dates. For example, adding lead days to the billing effective date to ensure the billing notice arrives prior to the due date. Another example is to add time on to a date, such as using the DaysAdd function to increment a date value.
Function 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 Function Math Variable
Drag and drop the Function 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.
-
The Data Type for the value of the math variable. This data type corresponds with the result or outcome of the Function Call. The applicable data type selection is defined as: Activity, Boolean, Date, Decimal, Integer, Map, Object, or Text. This is required.
-
Make sure variable type is defined as Function. This is required.
-
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 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.
-
The Call requires the Function Name and parameters. For example, DaysAdd(IssueDate, BillingLeadDays). The parameters may be a previously defined math variable or a combination of a previously defined math variable and a hard-coded value. For example, MonthsAdd(EffectiveDate, 1).
Check-in the transaction to save the information to the database.
Copyright © 2009, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices