Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
How to convert a field (formula) from number to text or vice verse — 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

How to convert a field (formula) from number to text or vice verse

Received Response
23
Views
5
Comments
edited Jan 14, 2020 9:44PM in Reporting and Analytics Taleo Enterprise 5 comments

Summary

Would like to combine two columns using CASE statement, one is with number format, the other is with text format

Content

I have two columns in one report. Both of them are working fine.

One returns number type: CASE WHEN "Requisition Flex Fields"."UDF29" = '29A' THEN CAST(REPLACE(REPLACE(REPLACE (LEFT ("Requisition Flex Fields"."UDF30", 7), '$',''), '-', ' '), ',', '') AS DOUBLE) END/ CASE "Requisition Flex Fields"."UDF22" WHEN '22A' THEN 165.333 WHEN '22B' THEN 156 END

The other one returns text type: CASE WHEN "Requisition Flex Fields"."UDF29" = '29B' THEN REPLACE(LEFT("Requisition Flex Fields"."UDF30", 7),'$','') END

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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