Report w Running Sum Fields (1 Viewer)

[Robecca]

I have a report about bowlers & series. I am attempting to do a running sum on each bowler's series & games bowled each week, so I can get a new composite average each week.

The data looks good until the 2nd to last row of data. The running sum on series & games bowled for every bowler is blank even though I have a series that week for all bowlers. And the averages for that week show a 0. The very last row of data for all bowlers is fine and correct.

It is bizarre, has anyone else seen this and know of what I might try?

Thank you! Robecca

 

[billmeye]

It only takes one piece of invalid data to prevent a calculation from working. Look really hard at your data and if there is a null or non-numeric or non-date etc. that is needed for the calculation you'll get what is happening to you.

 

[Mihail]

On the other hand, if the very last total is OK then the data should be OK.
Where is the location for running sum control ? It should be placed in the footer of THAT group (week in your case).

 

[Robecca]

I rechecked my data for the week of 6/25 and there were no issues.

I have the running sum control in the detail. I wanted to know by Bowler their composite average on any given week during our league.

I never thought about the week footer, I will give it a try.

It is fine