Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Creating Running total from a Formula field

Status
Not open for further replies.

WinterDragon

IS-IT--Management
Jul 21, 2004
28
US
I have an assemblies report. List the Assembly Name, then under the Named groupd shows the component Description, Qty needed, quantity on hand, and the @Division formula, devides the quantity on hand by the qty needed, to tell me how many cases I can produce.

Now what I am wanting to do, is in the group heading (The Assembly name) I want a running total (Or Similar) to display the Smallest number of cases. This way if an item only has enough to make 1 case, and another item might have 6,000, I want to know that I can only make 1 case.

If this doesnt make sense, I will try to explain in greater detail.

Any help would be apprecaited...

WinterDragon
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top