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