Joined: 10 Jan 2011
Location: South Africa
Online Status: Offline
Posts: 4
Topic: sum issue on weight field Posted: 31 Jan 2011 at 12:04am
Hi People,
A client wants a total weight listed on his invoice form. I have put in the field that lists the unit weight of the items and suppressed it. I made a summerized string of the unit weight field and its in the report footer.
It picks up the weight but then it doubles the weight. So i put in one item, unit weight of 100kg's and the sum string shows 200kg's. Anyone knows why its doing this?
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 01 Feb 2011 at 3:56am
What are your 'summarized string' formulas. If you are using vatriable formulas you may be counting an extra row that is actually the footer.
Usually you need 3 formulas for this type of thing, A reset formula in a header, a formulas to calcualte per row and a formula to display the results in the footer
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
