Running total based on a formula

[WinterDragon]

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

 

[synapsevampire]

Try a formula containing:

minimum({table.qty},{table.Assembly})

-k

 

[WinterDragon]

I am still rather new to Crystal and I am not quite sure I am following which table you are referring in ({table.qty}) Would this be like ({Lineitem.qty}) ?

If so, what would the second Table be?

I have 3 tables.. BOMItems, Lineitem and Lineitem_1

Qty On Hand is pulled using a Peachtree Formula in Crystal


Assistance would be greatly appreciated

Winterdragon