Backlog

[SMosley804]

Crystal 11

I am attempting to created a backlog report that captures the following

Created Closed Backlog

1/1 10 5 5
1/7 15 10 10
1/14 20 25 5

The report is grouped by opendate. the problem is that I need to be able to add the prior weeks backlog to the current week.

any suggestions?

 

[lbass]

Create a formula:

{table.created}-{table.closed}

Then sum this in a running total that doesn't reset and display this as the backlog.

-LB