In a Constituent Export when a Total Gift Amount field includes a selected campaign query, the field does not consider write offs.
We are currently evaluating this issue and will update this article when we have more information.
Steps to Duplicate
1. Create a new constituent export 2. On the Output tab under Available Fields to Export, select Total Gift Amount under Summary information 3. On the Filters tab next to Campaigns, enter Selected 4. Include a Campaign Query 5. On the Gift Types tab, select Pledge and Write Off 6. Click OK 7. The amount exported does not subtract the write off amount