Oracle Transactional Business Intelligence

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

Replace

Question
21
Views
0
Comments

I am using the measure specified below to replace '-' for '/' in string.

CASE WHEN "Input Value"."Input Unit of Measure"='D' THEN REPLACE(CAST("Element Entry Value"."Displayed Input Value Meaning" AS VARCHAR(200)), '-', '/') ELSE "Element Entry Value"."Displayed Input Value Meaning" END

It's not causing an error but not working either.

Any pointers would be much appreciated.

Thanks in advance.

Tagged: