Social Icons

Wednesday, August 14, 2013

How to add Functions to Fast Formulas

Assignment
Edit your Travel Payment formula to ensure that the result is always rounded to two decimal places.
Using the Round Function Edit your Travel Payment formula to ensure that the result is always rounded to two decimal places. It can be done by using functions in Fast Formulas.

Using the Round Function
1. Navigate to the Formula window using your local Super HRMS Manager responsibility. Total Compensation > Basic > Write Formulas
2. Set your effective date to 1 January 2000.
3. Query XX_TRAVEL_PAYMENT, where xx is your group identifier.
4. Select the Edit button.
5. Add the Round function to your formula, and verify it.
6. When the formula verifies successfully, close the Edit Formula window.
7. Save your work.
8. Select Correction.

Your formula should be similar to the following:
DEFAULT FOR distance IS 0
DEFAULT FOR override_travel_rate IS 0
INPUTS ARE distance, override_travel_rate
IF override_travel_rate WAS DEFAULTED
THEN
travel_payment = ROUND((distance * XX_COMPANY_TRAVEL_RATE),2)
ELSE
travel_payment = ROUND((distance * override_travel_rate),2)
RETURN travel_payment

Please share your views about this Article.For more articles visit About ERP Oracle Apps

No comments :

Post a Comment

">