For more information, please refer to this announcement explaining best practices for getting answers to questions.
Replacing a text from a result of Case When
Content
I am converting a formula from BO to OBI but unfortunately I am encountering an error. Below is the BO formula:
Replace(Replace(Replace(If(Match([Event];"Status changed to*") And ([Application Tracking CSW Status])<>"Rejected") Or Match([Event];"Revert*") Then ("Event date: "+[Application Tracking Event or Transaction Date]) ElseIf([Event]="Correspondence sent") Then [Application Tracking Correspondence Template Used (7.5 Legacy Data)] ElseIf(Match([Event];"Service*")) Then Replace(Replace([Application Tracking Details];"{service}";[Application Tracking Passport Services Name]);"{provider}"; [Application Tracking Passport Services Provider]) ElseIf([Application Current CSW Step]<>"New" And [Application Current CSW Status]="Rejected") Or IsNull([Application Tracking Details]) Then [Application Tracking Motives] Else [Application Tracking Details];"Question: ";("Question: "+[Application Tracking Q&A Question (Before Update)]));"{1}";"_");"{SEPARATOR}";"