Convert whole number to Decimal in fast formula — Cloud Customer Connect
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

Convert whole number to Decimal in fast formula

edited Apr 19, 2024 5:46AM in HCM Extract 1 comment

Hi Team,

We have a requirement to convert the number with two decimal positions. I am able to do with Round/Round_up function for decimal numbers.

However, if it is a whole number (without decimal positions) , not able to convert it.

Even I tried to concatenate the decimal positions, but the decimal positions are missing when I convert that to number.

Can you please suggest if we have any function or other way to achieve this ?

Below is the ode snippet I tried,

l_run =561

l_run=TO_NUMBER(TO_CHAR(l_run)||'.00')

log= ess_log_write('l_run'||to_char(l_run))

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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