Hi All, I need help in Fast Formula, the logic for that is If my net pay is 11220 then I will be paid 11300 . I need to floor(net pay) but I am not getting where to write the formula. Thanks Ajay

Use the following in ur sql statement or in pl/sql block to get as required, Code (SQL): SELECT TRUNC(<column_name>,-2)+100 FROM DUAL; eg, SELECT TRUNC(11220,-2)+100 FROM DUAL;

Hi, I am trying to write the following fast formula example for you as you are not know how to write fast formula so that's why I try my level best to provide the whole example from defining the values till geneate the payslip: For example I will Truncate the Basic Salary of an Employee, the value of Basic Salary Define in the system is : see attached image 1.jpeg Now write the Fast Formula to truncate the basic Salary: Open the Write Formula window and paste the following code: -------------------------------------------------------------------- DEFAULT FOR BASIC_SALARY_PAY_VALUE_START_DATE IS '28-OCT-1974' (Date) DEFAULT FOR BASIC_SALARY_PAY_VALUE_END_DATE IS '01-JAN-3000' (Date) DEFAULT FOR BASIC_SALARY_ASG_ITD IS 0 DEFAULT FOR FIXED_SALARY_ASG_RUN IS 0 DEFAULT FOR MONTHLY_AMOUNT IS 0 DEFAULT FOR ABSENCES_SALARY_PAY IS '0' DEFAULT FOR GROUP_KF_ACTIVITY_TYPE IS '0' ALIAS FIXED_SALARY_ASG_RUN AS Fxd_Sal_Amt ALIAS BASIC_SALARY_PAY_VALUE_START_DATE AS E_Start_Date ALIAS BASIC_SALARY_PAY_VALUE_END_DATE AS E_End_Date ALIAS BASIC_SALARY_ASG_ITD AS B_IT ALIAS GROUP_KF_ACTIVITY_TYPE AS Activity_Type Inputs ARE Monthly_Amount Days_In_Current_Period = DAYS_BETWEEN(P_End_Date,P_Start_Date)+ 1 Actual_Value=Monthly_Amount Pay_Amount = TRUNC(Monthly_Amount,-2)+100 mess='Fast Formula TRUNC Example' || TO_CHAR(Pay_Amount) Return Actual_Value,Pay_Amount,mess ----------------------------------------------------------------------------------------------------------------------- Link the output of Fast formula to the Basic Salary Element : see attached image 2.jpeg Run the Quick pay to check the output of your Fast Formula result: see the attached image 3.jpeg Click the View Result Button and select the “Run Results” from the popup window: see the attached image 4.jpeg Then select the Basic Salary Element from the Element Name List and press the “Run Result Values” Button, following window will be display: see the attached image 5.jpeg Hope this will help you. Regards, Muzamil Khan (muzzamil.khan@gmail.com)

Hey, I have been also using this formula, it's very easy and informative. These Fast Formulas are very helpful in Oracle Payroll. You can use it easily. Thanks..

Dear Muzamil Khan I have seen your useful fastformula example above, I am newbie on that domain of writing fastformula. would u like to share some knowledge with me....? kindly please send me more notice or any e-books etc.. mramadhani@email.com