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 convert a text UDF to a number for use in a calculation

Received Response
63
Views
3
Comments
edited Jul 15, 2016 11:51PM in Reporting and Analytics Taleo Enterprise 3 comments

Summary

We have a UDF to capture the Commission amount and a UDF to capture the Total Target Comp for Sales offers. I want to calculate the commision split in OBI but it see the field as a text field.

Content

I used the CAST function to attempt to convert the UDF to a number using CAST("Submission Job Offer Flex Fields"."UDF19" AS INTEGER).  OBI accepts the formula but i am unable to use it to calculate the split so it doesn't seem to being seeing it as a number after all.  Any help would be greatly appreciated.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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