Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: Running Sum Changes when not visible
Started 1 month ago by Sheri
I have a subreport with a running sum which is referenced (=[RunningSum]) in the main report under a grouping footer. When the running sum is visible it totals properly and the referenced amount equals the running sum, but when I change the running sum so it's no longer visible the referenced amount changes and is off $500. This amount doesn't seem to tie to anything that i can tell....
Site: Microsoft Office (Excel, Word) forum - OfficeFrustration  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile
Forum: Setting Up & Running Reports  Setting Up & Running Reports - forum profile
Total authors: 1 author
Total thread posts: 3 posts
Thread activity: no new posts during last week
Domain info for: officefrustration.com

Other posts in this thread:

Sheri replied 1 month ago
Clarification: Running Sum not part of subreport - it is in the detail section of the main report referencing to the subreport . "sheri" wrote: I have a subreport with a running sum which is referenced (=[RunningSum]) in the main report under a grouping footer. When the running sum is visible it totals properly and the referenced amount equals the running sum, but when I ...
Size: 759 bytes
Customize:  Customize "<b>Reply 1</b>: Running Sum Changes when not visible :: Setting Up & Running Reports :: Microsoft Office (Excel, Word) forum - OfficeFrust..."

Sheri replied 1 month ago
I've identified where the error is occuring but I still don't understand why. Also, I mispoke in my second post the running sum is in the grouping footer next to the subreport (also in the grouping footer). So for one of my records it is picking up half the amount. It shows the total for the record to be $1000 but only adds $500 to the running sum. The record is the sum of two $500...
Size: 1,576 bytes
Customize:  Customize "<b>Reply 2</b>: Running Sum Changes when not visible :: Setting Up & Running Reports :: Microsoft Office (Excel, Word) forum - OfficeFrust..."

 

Top contributing authors

Name
Posts
Sheri
3
user's latest post:
Running Sum Changes when not...
Published (2009-11-10 17:41:00)
I've identified where the error is occuring but I still don't understand why. Also, I mispoke in my second post the running sum is in the grouping footer next to the subreport (also in the grouping footer). So for one of my records it is picking up half the amount. It shows the total for the record to be $1000 but only adds $500 to the running sum. The record is the sum of two $500 amounts. It is not the only record with two amounts...

Related threads on "Microsoft Office (Excel, Word) forum - OfficeFrustration":

Sum If Visible  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile General Discussion - forum profile Sum If Visible
Sum If Visible
Running Sum + initial value  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile Setting Up & Running Reports - forum profile Running Sum + initial value
Running Sum + initial value
Update for running sum  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile Running & Setting Up Queries - forum profile Update for running sum
Update for running sum
Running sum in report with a previous month total and...  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile Setting Up & Running Reports - forum profile Running sum in report with a previous month total and current mon.
Running sum in report with a previous month total and current mon.
Running sum not correct  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile Setting Up & Running Reports - forum profile Running sum not correct
Running sum not correct
Help with DSum to create running sum  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile Running & Setting Up Queries - forum profile Help with DSum to create running sum
Help with DSum to create running sum
Running Sum vs OutputTo  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile Setting Up & Running Reports - forum profile Running Sum vs OutputTo
Running Sum vs OutputTo
I can not find running sum in my properties box for...  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile Using Forms - forum profile I can not find running sum in my properties box for access 2003
I can not find running sum in my properties box for access 2003
Running Sum with conditions  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile Setting Up & Running Reports - forum profile Running Sum with conditions
Running Sum with conditions
Another Running Sum  Microsoft Office (Excel, Word) forum - OfficeFrustration - site profile Setting Up & Running Reports - forum profile Another Running Sum
Another Running Sum

Related threads on other sites:

Running Sum Changes when not visible in...  Discussions in microsoft.public.access.reports - site profile microsoft.public.access.reports - forum profile Running Sum Changes when not visible in microsoft.public.access.reports
Running Sum Changes when not visible in microsoft.public.access.reports
Running Sum for the Month.  BOB: BusinessObjects Board - site profile WebIntelligence XI - forum profile Running Sum for the Month.
Running Sum for the Month.
Only sum formula visible, not actual sum  OpenOffice.org Forum at OOoForum.org - site profile OpenOffice.org Calc - forum profile Only sum formula visible, not actual sum
Only sum formula visible, not actual sum
Tray icons are not visible. They are running but not...  Microsoft Answers Forums - site profile Windows XP Forums Desktop and personalization - forum profile Tray icons are not visible. They are running but not visible except for kaspersky and idm icons.
Tray icons are not visible. They are running but not visible except for kaspersky and idm icons.
A couple things I'm learning about making goals is keepem...  Twitter / santz85 - site profile santz85 - forum profile A couple things I'm learning about making goals is keepem simple and attainable, categorizem, b specific, n keepem sum where visible. 8:57 AM Sep 3rd from UberTwitter
A couple things I'm learning about making goals is keepem simple and attainable, categorizem, b specific, n keepem sum where visible. 8:57 AM Sep 3rd from UberTwitter
Updated emacs-fu: tracking changes with...  Twitter / djcb - site profile djcb - forum profile Updated emacs-fu: tracking changes with higlight-changes-visible-mode ( http://bit.ly/TDyCg 12:53 PM May 26th from twitter.el
Updated emacs-fu: tracking changes with higlight-changes-visible-mode ( http://bit.ly/TDyCg 12:53 PM May 26th from twitter.el
Glad about sum changes in True Blood characters but hate...  Twitter / meliafairy - site profile meliafairy - forum profile Glad about sum changes in True Blood characters but hate the changes w/ Bill n Eric. If ur gonna change somethin big then it better b good! 8:08 PM Aug 9th from TwitterBerry
Glad about sum changes in True Blood characters but hate the changes w/ Bill n Eric. If ur gonna change somethin big then it better b good! 8:08 PM Aug 9th from TwitterBerry
Help: Running Sum (or Cumulative Sum)  p2p.wrox.com Forums - site profile Beginning VB Databases - forum profile Help: Running Sum (or Cumulative Sum)
Help: Running Sum (or Cumulative Sum)
Conditional sum of visible cells in a filtered list  AllExperts Questions/Answers - site profile Excel - forum profile Conditional sum of visible cells in a filtered list
Conditional sum of visible cells in a filtered list
Calculate running sum (Cumulative sum) in VB6  Xtreme Visual Basic Talk - site profile Database and Reporting - forum profile Calculate running sum (Cumulative sum) in VB6
Calculate running sum (Cumulative sum) in VB6
Thread profile page for "Running Sum Changes when not visible" on http://www.officefrustration.com. This report page is a snippet summary view from a single thread "Running Sum Changes when not visible", located on the Message Board at http://www.officefrustration.com. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity