What's new in Customer Journeys?

Connect and learn more!
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
edited Dec 13, 2022 7:10AM in Taleo Enterprise 5 comments


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


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.


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