Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Comments
-
I have tried below in OBIEE RPD and ANalytics to get the Month1 and Month2 amount values --SUBSTRING("Core"."AMT" FROM 0 FOR cast(EVALUATE('instr(%1,%2)' , "Core"."AMT",']')as int)-1)--Month1 --SUBSTRING("Core"."AMT" FROM 9 FOR cast(EVALUATE('instr(%1,%2,%3)',"Core"."AMT",']',2)as int))--Month2 its working for to get the…