Combining CONCAT and other Functions to Calculate String Values

You can combine the CONCAT function with other functions to calculate complex string values. For example, to show duration values in days and hours, first normalize the values with TO_NUMBER and TO_NCHAR, then use this formula. The output type is STRING:

          CONCAT(CONCAT('Days: ',TO_NCHAR(FLOOR(TO_NUMBER(TO_NCHAR({timeelapsed}/24))))),
CONCAT(' Hours: ',TO_NCHAR(MOD(TO_NUMBER(TO_NCHAR({timeelapsed})),24)))) 

        

Try using different formula functions with the CONCAT function to calculate other string values.

Related Topics

• Advanced Sample Formula Fields
• Calculating Duration Values with TO_NUMBER and TO_NCHAR
• Casting Field Values using TO_NUMBER and TO_NCHAR
• Currency Consolidation and Conversion Using Custom Formula Fields
• Conditional Evaluations Using CASE WHEN
• Calculating Amounts for Relative Date Ranges
• Calculating Specific Dates

General Notices