I have a running total (sum of weights) that is resetting every time a particular field changes.  However, that total doesnt show on the last record in the report.

 

I think that is because

1) The sum is based on the change of field and on the last record that field is not changing

 

how do I get a running total to sum the last record.

I tried to change the total reset options from "on change of field" to a formula:

If {field} does not equal the next {field} then

set sum to 0

else onlastrecord

sum = sum + weight

 

its not working.... and I need help

thanks