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.