I have a report I use once per year, which contains a bucket field that buckets a custom lookup field from Opportunity to a custom object.
During this past year, our org changed the name (Name field) of a few records on the looked-up object. Small changes, like "Innovative Teacher Grants" changed to "Impact Teacher Grants".
This caused two failures in the report:
* The old bucket value did not get auto-updated to the new name for that record, which caused that record's Opportunity value to appear in the wrong bucket (it appeared in the Other bucket, which I had checked).
* I couldn't figure out any way to delete the old bucket value from its bucket.
I could fix the report by leaving the old bucket value where it was, and adding the new, renamed record name as a bucket value.
Any thoughts on how to remove the old bucket value, and on whether there is an issue report or idea on fixing this? Or maybe I'm doing something else wrong and it's not really an issue?
