I have a report that is both Detail and Summary. My issue is that the detail portion does what it is supposed to do, that is to substitute the input if their is an input for the line item. However; when I go to summarize it, the Summary overlooks the new total and places in the substitute total "line item" instead of the new Sum .