Skip to Content

Replace function where condition is met

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

Add comment
10|10000 characters needed characters exceeded

  • 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.

  • Get RSS Feed

2 Answers

  • Apr 12 at 08:53 AM

    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"

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 12 at 12:57 PM

    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

    Add comment
    10|10000 characters needed characters exceeded