1. Create a new gift attribute of "Written Off."
  2. Add this gift attribute to each pledge that has been completely written off.
  3. Within the Summary information filter in the constituent query, exclude gifts with that attribute.