Formula Problem Running Totals

[willyd61]

I am having what I think should have been pretty straightforward formula. I am using CR 8.5 against Remedy.

Anyway, I have a report that I am creating that counts Ticket numbers that are generated after a certain date, then count the number of tickets and report those in each column.

For instance:
Resolved - Closed
LastHour- 5 4
Last8Hours- 21 15

What I did first was make a formula that takes current-time and subtracts 3600 seconds. I did this by doing CDateTime(CurrentDate,CurrentTime-3600) and saved this as my lasthour formula.

I then start a running total field with TicketID being my Field to Summarize with type = count.

Then in my Evaluate I choose to do a formula with ResolvedDate > lasthour

Then I never reset. I do this for each column and each results set I want. then I place these running totals in the Report Footer.

Now the numbers are not right? What is going on, also the details section is as big as my RecordSelection from the get go (which is when I selected only the division that I want for things occurring in the past week, this allowed me to return recent records) which is 135, so I have 135 details sections before my footer comes up.

at first I was going to do this in a cross-tab report but you can not have a row or column be determined by formulas.

Anyway, any help on this would be much appreciated, my ops department is pushing this hard for some reason, and usually I have more to work with then just this create/resolved dateTime.

Wlipford - TNS

 

[willyd61]

Any Ideas guys?

 

[lbass]

Well, you can use formulas in crosstabs unless they include next or previous functions or use summaries. Please explain what "Resolved" and "Closed" are--fields? formulas? If they are formulas, please share. Are you working with only one date field?

-LB

 

[willyd61]

I ended up getting it to work with Running Totals instead of Cross-Tab.

Thanks anyway lbass.