-
August 5th, 2009, 05:21 PM
#1
[RESOLVED] Inserting a Subtotal
Simple enough right?
Well let me tell ya.. I have a formula that I use to calculate the total amount in the original order and I compare it to what actually shipped. I would like to have a subtotal for the week and one for the month.
The problem is when I try to insert a subtotal option it's grey'd out. Is there another way I can do this?
This the formula that calc the difference;
Sum ({@OrigQtyOrd}, {oehdrhst_sql.ord_no}) - {oehdrhst_sql.tot_sls_amt}
Thanks for your time..
-
August 5th, 2009, 07:03 PM
#2
Re: Inserting a Subtotal
Insert a new formula field that calculate the difference but place it at Detail Section
Then you can add a subtotal for that new formula field
-
August 24th, 2009, 01:10 PM
#3
Re: Inserting a Subtotal
Thanks jggtz, I had to do several other things to make it work but the info you gave helped a great deal.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|