Created a report comparing Revised Estimated Cost to Actual Cost. The "sum" of the Revised Estimated Cost is giving me problems. When I try to "Sum" that field, it totals by the number of times the cost code is used...therefore the "sum" becomes overstated. All I want is the Revised Estimate amount shown on the "Status" tab of the Job.
292
370