You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to remove decimal zeros in Fast Formula

edited Sep 5, 2020 12:33AM in Payroll and Global Payroll Interface (GPI) 1 comment

Summary

How to remove decimal zeros in Fast Formula

Content

Hi Experts,

I am working on HCM Data Loader Fast Formula. In my input file, I am having the values 1958.00, 1958.50, 1958.57 etc. If my input value is 1958.00, then it should fetch only 1958. If my input is 1958.50, then it shoud be 1958.5. If my input is 1958.57, then it shoud be 1958.57. So basically it should remove all the zeros after the decimal point. 

It would be very helpful if someone provide some syntax to achieve this.

Thank in advance. 

Best Regards,
Nirmal Kumar

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!