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

[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