CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2009
    Posts
    14

    [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..

  2. #2
    Join Date
    Jul 2005
    Posts
    1,083

    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

  3. #3
    Join Date
    Jun 2009
    Posts
    14

    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
  •  





Click Here to Expand Forum to Full Width

Featured