Convert a number to a fraction BIP report

Question

Hi all,

Is there a function sql to convert a number to fraction using  a BIP report in Oracle HCM? For example if I have 0.25 FTE value, I want to print the fraction 1/4.

Do you have suggestion for it?

Best Regards,

Teresa

Mallikarjuna Kuppauru-Oracle · Answer

HI @teresa.marciano

You can write an function & use the same -

Convert a decimal to it's fraction representation - Ask TOM (oracle.com)

Regards,

Arjun