If I'm understanding what you want to do, then I think you can create a calculated field to replace Branch with the correct values. In fact, if you create a calculated field named Branch it will replace the existing field. The following code will retain all current values, except in the case of NRC.RCN where values from the Division will be used instead:
IF [Branch] = "NRC.RCN"
Hope that helps!
Thank you for the quick reply Joshua. You stated my issue correctly. Unfortunately this did not solve the problem. The calculation results in the exacts same values in the Branch field. NRC is not divided and renamed as the subcomponents.
That's odd. A couple of things to try:
- What happens if you name the calculation something other than Branch? Any difference?
- What happens if you double click that branch in the Profile Pane (where it is highlighted in your image above) and then copy the value and paste it into the calculation. I'm wondering if there are some leading or trailing spaces or another character of some kind that might not result in equality in the calculation I provided.
- Double check that possibility with a calculation that is simply: [Branch] = "NRC.RCN"
- If there are no TRUE values, then something is up with the string in the calculation.
The calculation worked well. I copied the text from the branch field and pasted it into the calculation and it worked perfectly. Not sure what the difference was but I will remember that for the future. I am glad the calculation is not too complicated. I really need to find a course or training video just focused on calculations.