Replace Function in SAP analytics cloud

[former_member1316811]

Hi Everyone,

I have a dimension with a list of project number that looks like this.

IN.20037820

I am trying remove the dot in the middle so that it is trimmed down to IN20037820.

So I tried to create a calculated dimension, using the REPLACE function,

REPLACE([d/"Status and Commentary":Project_Def_1f3z41s68l] ,'.','')

but I get this error.

Not sure what it means by choose a property, or how to choose a property, hoping someone here has a clue.

"Formula could not be computed: Choose a property for dimension "Project_Def_1f3z41s68l" in function "REPLACE". Please complete or rewrite the formula."

question.png

[former_member1316811]

Thank you it worked.

[N1kh1l]

steve5232

Try something like below. You need to provide which property (ID, Description etc ) of dimension you want this replace action on.

REPLACE([d/"EMPLOYEE":WD_EMPLOYEE].[p/ID],".","")

Hope it helps !!

Regards

Nikhil

[Susanne_Helbig]

Hi steve5232,

the formula is written with semicolon and you need to specify the property of the dimension you want to change.

Try something like this:

REPLACE([d/"Status and Commentary":Project_Def_1f3z41s68l] .[p/ID];".";"")

Best regards
Susanne

[mfoeken]

Hi Steven,

Have you tried using double quotes: "." ?

Kind regards,

Martijn van Foeken | Interdobs