1 of 1 people found this helpful
If this is just a once off - how about creating a calculated field that has a calcuation like :
if value = x then y else z
You can then use this calculation instead of the values and it'll calculate all the totals correctly.
Of course if you are changing lots of values this will become a maintenance problem but it will work for an odd error.
Hope this helps
Thanks Peter, this is certainly a helpful work-around. I'm worried that my client may not be savvy enough (or willing) to script. But this is definitely helpful!
If anyone else has an idea, please let me know!