Running Sum: I need data in all cells in crosstab

[marceg]

I have a crosstab with the function running sum in the body: “=(RunningSum(<Income Total>;<Account Description>)*-1)/1000)”.
But when the variable doesn't have values for some of the columns (NOT NULL, IT DOESN’T HAVE ANY VALUE). If this is the case, the running sum is blank for that cell. Is there any way to get the running sum to fill all cells?

Example:
Jan Feb Mar Apr
Inventory 12 20
AccPay 20 35
WorkCap 15 28 35 48

 

[skrandel]

I've had the same problem. The RunningSum function gives you the running total of columns where data actually exists. In a crosstab, the cell isn't really empty, it's non-existent. So, you can't solve this problem at the report level.

What you need to do is either put dummy data in the database so that this problem doesn't happen, or build a union query that returns 0s for all the cells that could exist in your crosstab.

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com