Replace

Is it possible to create a "Replace and Look up" statement in one field?

I created the following:

=Lookup(Fields!Account_Number.Value,Fields!Account_Number.Value, Fields!Task_Notes.Value, "TaskingResponse")

I want to replace results "Not Acute" with "denied"

I tried the follwoing and it did not work

=Lookup(Fields!Account_Number.Value,Fields!Account_Number.Value, Fields!Task_Notes.Value, "TaskingResponse" & replace (Fields!Task_Notes.Value,"Not Acute","Denied")

Thank you

January 30th, 2015 10:46pm

Are you looking for the below expression,

=Lookup(Fields!Account_Number.Value,Fields!Account_Number.Value, replace (Fields!Task_Notes.Value,"Not Acute","Denied"), "TaskingResponse")

Free Windows Admin Tool Kit Click here and download it now
January 31st, 2015 6:00am

=Replace(Lookup(Fields!Account_Number.Value,Fields!Account_Number.Value, Fields!Task_Notes.Value, "TaskingResponse"),"Not Acute","Denied")

January 31st, 2015 10:29am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics