Rounding
This formula type can be used to round coverage or rate values.
Contexts
The following contexts are available to formulas of this type:
- BUSINESS_GROUP_ID ( ENTERPRISE_ID)
- EFFECTIVE_DATE
- HR_ASSIGNMENT_ID
Database items
Use only the following database items that are available to formulas of this type:
- Database items based on person’s assignment – HR_ASSIGNMENT_ID
Input Variables
Input variables are not available to formulas of this type.
| Input | Data Type | Required | Description |
|---|---|---|---|
| VALUE | NUMBER | Y | Value to be rounded |
Return Variables
Use predefined names for return variables. The following return variables are available to formulas of this type.
| Return Value | Data type | Required | Description |
|---|---|---|---|
| L_OUTPUT | Char | N | Returns rounded value |
Errors
If any other output value is returned then the participation process errors with BEN_91329_FORMULA_RETURN.
| The formula BEN_ROUNDING returned an invalid value. |
Sample Formula 1:
FORMULA NAME: BEN_ROUNDING
FORMULA TYPE: Rounding
DESCRIPTION: Round up value to 2 decimal places. Ex - (123.17792,2) WOULD result in 123.18
INPUTS are VALUE
DEFAULT FOR VALUE IS 0
l_input_val = VALUE
l_output = ROUNDUP(l_input_val,2)
return l_outputSample Formula 2:
FORMULA NAME: BEN_ROUNDING_UP
FORMULA TYPE: Rounding
DESCRIPTION: Round value
INPUTS are VALUE
DEFAULT FOR VALUE IS 0
l_input_val = VALUE
l_output = ROUND(l_input_val,2)
return l_output