User_JRMG3 — Oracle Analytics

Welcome to the Oracle Analytics Community

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

User_JRMG3 Rank 1 - Community Starter

Comments

  • Does anyone know if there has been a solution to this? Attempting to format a column's width via Column Properties, Format Headers or Format Values doesn't do anything. Unticking Wrap Text means that the Column width extends the cell out to the longest value of characters.
  • Hi, I have managed to solve my issue via the use of SUBSTRING and CONCAT. ****** CASE WHEN "CommercialContractLaunch_c"."FieldAlert1IssuedSupportingInfo_c_Meaning" IS NULL THEN CONCAT(CONCAT( CONCAT(SUBSTRING(CAST("CommercialContractLaunch_c"."FieldAlert1Issued_c" AS CHAR),9,2), '/'),…