I am trying to create a graph that shows the running sum of budget
compared to actuals. I have setup union queries that work great for
getting the running sum for budgets and actuals.
However when I combine these 2 queries I can get zero's that will throw
off my graph.
For instance.
Actuals Running Sum
jan 10 10
feb 5 15
Apr 2 17
Budget Running Sum
Jan 8 8
Feb 10 18
Mar 5 23
Combined I get:
Month Actuals Budget
Jan 10 8
Feb 15 18
Mar 0 23
Apr 17 0
This makes my graph go to zero instead of running.
Any help would be much appreciated
thanks,
KO