Jump to content

Summary report two tables running total

Recommended Posts

I have searched the forums, but haven't found an answer to this. I have a file with two tables, received and shipped. Have successfully created a report by month with total received and total shipped and the difference between the two. What I would like to do and cannot figure out is to have another field which keeps a running Balance on Hand as illustrated below. My results do not reflect this, not sure what I need to do at this point, attached is file. Thanks for any help and sorry if this has been answered before.

Month         Received      Shipped    Difference       Balance on Hand

Jan 2016     425               400                    25                    25    Can't get this column to report correctly

Feb 2016     370               350                   20                    45

Mar 2016     340               270                   70                  115

April 2016   310               400                   (90)                  25



Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Who Viewed the Topic

    1 member has viewed this topic:
    Terrible Toll 
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.