Get Started with Redwood for Oracle Cloud HCM Begin Now
How to convert a text UDF to a number for use in a calculation
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.
0