Any suggestions would be greatly appreciated.

 

Thanks,

CoachGBT

 

Previous Month Total + OPEN Status - RELEASE Status = BACKLOG or End of Month Total.

 

Now Previous Month Total doesn't have a starting value, but I intend to use End of Year total as my Previous Month Total (Dec 2011) value to carry over for the start of 2011 (Jan).

Previous() is a function that is referencing exacly the row above a row, it is not in reference to anything else. So your "Previous Month Total" was asking for the value from a field called "month Total" from the previous row of data. That is a non-existent field hence the error you got.

I think I see what you are trying to do here but not being familiar with your data it is very difficult to tease out.

I am assuming you have several if then formulas here that make a 1 or 0 based on your conditions.

You can used shared variable formulas to do conditional adding or subtracting (passing a value to the next row/group) but i think I would do this a little differently (as I prefer Running Totals anyway). This is not answering your question directly because I think the path you are on is going to get too convoluted and I would restart down a different 'cleaner' path...

 

Create one RT for the Year start

name=yearstartamount

field to summarize=whateer field is your 145 value

type = sum

evaluate=use a formula

reset=never

//this gives you one constant value for the entire report

another RT

name=monthlycreated_reset

field to summarize={@CREATED CT}

type=sum

evaluate=for each record

reset=group ({@NEW_DATE})

 

 

 

1 place each individual RT on the detail lines and scrutinize each one per row and group footer to make sure it is doing what you want/expect. My initial guess is that for each of the "NO_reset" RTs you accidently have then reseting on each group.

Let me know what you find when you look ata each RT.

Thanks for all your help.

 

I have a question about Cross-Tab:
I have a Formula (the formula has RT Fields) and I want to add the Formula to Cross-Tab as a Summarized Field. When I open the Cross-Tab Expert, the Formula I want to add doesn't appear in the list of Report Fields to choose from.

 

So far the Cross-Tab has eleven columns,  months (Jan - Oct) and Total, and two rows this is all fine and well. My two rows are:
Created CT
Released CT
I want to add a third row:
Backlog CT (And for Backlog CT I want to use the Formula that has RT Fields). This is the formula:

 

Thanks Again,

CoachGBT