cancel
Showing results for 
Search instead for 
Did you mean: 

Replace function where condition is met

0 Kudos

I am looking to replace text in one object where a condition is met in another object. The example being that I have unknown being presented as an outcome in one object but it is related to two different outcomes in another object. I want to distinguish between the both if possible. What I have came up with so far is just bringing back blank outcomes

=Replace([Case Created By];"unknown";"WSSPortal") Where ([Case Category] = "Visit Request")

Any help would be much appreciated

denis_konovalov
Active Contributor
0 Kudos

As you do not mention any products that you are actually using, I have fixed your tags to match most common possibility.

Please do consider in the future that community members have no idea what product you are using and the formulas or sql logic might work differently in different products.

Accepted Solutions (0)

Answers (2)

Answers (2)

mhmohammed
Active Contributor

Hi Chris,

Create the below variable and let us know if it serves your request.

New Cast Created By

=If([Case Category]="Visit Request") Then Replace([Case Created By];"unknown";"WSSPortal")
Else [Case Created By]

Thanks,
Mahboob Mohammed

ayman_salem
Active Contributor

If I understood you correctly, just define the new variable "Case_Created_By" and use it instead of the original dimension.

Case_Created_By: =if ([Case Category] = "Visit Request") then "WSSPortal" else "unknown"