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

Rounding in OBI

Received Response
11
Views
2
Comments
edited Sep 1, 2023 7:10PM in Taleo Enterprise 2 comments

I need some assistance with rounding in OBI. I have formulas that calculate the number of days between two dates however the formula is rounding and putting only zeros after the period. You can see this in the screenshot below. I found a document in the knowledge base on rounding rules but it is not working. Below is the formula I am using for time to hire. How can I have the result populate a value like 1.23 instead of 1.00?

TIMESTAMPDIFF(SQL_TSI_DAY, "Requisition Dates"."First Sourced Date", "Submission Dates"."Offer Accepted Date")


Howdy, Stranger!

Log In

To view full details, sign in.

Register

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