Sum text box values from a lower sort group 1

[mongtrading]

Application is a commodity trading system.

I want to sum the dollars of profitable trades only (i.e. exclude losing trades) for a commodity.

Sort Group 1: Commodity
Sort Group 2: TradeNumber

In the TradeNumber footer I have the following two Text Boxes:

txtTradeProfitLoss:
=Sum(IIf([BuySell]="S",[Price]*[Quantity],-1*[Price]*[Quantity]))

txtProfitableTrade$:
=IIf([txtTradeProfitLoss]>0,[txtTradeProfitLoss],0)

In the Commodity footer I want to sum txtProfitableTrade$ from the TradeNumber footer. How is this done? =Sum(txtProfitableTrade$) prompts for input.

 

[CosmoKramer]

Check out thread703-146832.

 

[mongtrading]

Thanks Cosmo

That thread led me to Runningsum & Dlast - which gave me what I wanted.

Cheers