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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Can I sum a sum ?

Status
Not open for further replies.

damselx

Technical User
Apr 24, 2003
32
AU
Can I sum a sum ?

I have the following using v 9.0
Detail section (suppressed)
@1Qty
@4Qty
@9Qty

Group Section by Date I have
Sum of @1Qty
Sum of @4Qty
Sum of @9Qty
Date by Qty

Date by Qty is the following formula
Sum ({@1Qty}, {STKT.DATE}, "daily")+Sum ({@4Qty}, {STKT.DATE}, "daily")+Sum ({@9Qty}, {STKT.DATE}, "daily")

So if it’s selected by date, ie 1.4.03 – 5.4.03 I’d have 5 groups comprising of 3 lines & 1 total each

I want a grand total at the bottom totaling ‘Date by Quantity’ but don’t know how to do it

Thanks
Helen
 
Grand total:

Sum({@1Qty)+Sum({@4Qty})+Sum({@9Qty})

-LB
 
Oops--I meant:

Sum({@1Qty})+Sum({@4Qty})+Sum({@9Qty})

-LB
 
Thankyou !!

I tried that sort of thing but left out the Sum part

Thanks again
Helen
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top