Total value in reports

[deepucec9]

Created report, and would like to display total net weight and total gross weight.
As you can see in th attached files each case id has one or more record of net weight, so total gross weight will be Sum([netweight]+20)
It is working for first case id but gross weight data is wrong in the following ids. Please check the attached files.


gross weight= Sum(netweight_out]+20)

[JamesDeckert]

Don't really understand your formula but do you want this instead? Sum(netweight_out])+20
You are adding 20 to each occurrence of netweight, but maybe you are wanting to total the netweight, then add 20

[deepucec9]

Yes, I want to add 20 to the total net weight.
How is it possible?
please help

[JamesDeckert]

Sum(netweight_out])+20