Formula Help. 1

[BlurredVision]

I am running CR 9
I have been tasked to determine when the group IT SHIFT OPS does not take action on a problem
every two hours, only when they have ownership (When the group column is equal to IT SHIFT OPS). What I cannot seem to do is account for when the group changes from one
to another. Any ideas.. Thanks.



ACTION DATETIME GROUP

Problem Transfer 3/18/2004 9:01:51AM HELPDESK
New Problem 3/18/2004 9:01:51AM HELPDESK
Problem Transfer 3/18/2004 9:39:38AM IT SHIFT OPS
Add Work History 3/18/2004 9:41:15AM IT SHIFT OPS
Problem Forward 3/18/2004 9:43:36AM CSBEAR
Problem Transfer 3/18/2004 10:01:02AM CSBEAR
Status Changed 3/18/2004 10:01:02AM CSBEAR
Add Work History 3/18/2004 10:02:51AM CSBEAR
Problem Transfer 3/18/2004 10:05:49AM IT SHIFT OPS
Add Work History 3/18/2004 10:07:35AM IT SHIFT OPS
Problem Transfer 3/18/2004 10:08:02AM NTS
Add Work History 3/18/2004 10:17:49AM NTS
Add Work History 3/18/2004 10:20:25AM NTS
Problem Transfer 3/18/2004 11:05:08AM NTS
Problem Transfer 3/18/2004 2:31:00PM NTS
Status Changed 3/18/2004 2:31:00PM NTS
Add Work History 3/18/2004 2:33:01PM NTS
Problem Transfer 3/18/2004 2:42:22PM IT SHIFT OPS
Status Changed 3/18/2004 2:42:43PM IT SHIFT OPS
Problem Transfer 3/18/2004 2:42:44PM IT SHIFT OPS
Add Work History 3/18/2004 2:42:50PM IT SHIFT OPS
Problem Transfer 3/18/2004 9:15:30PM IT SHIFT OPS
Add Work History 3/18/2004 9:17:45PM IT SHIFT OPS
Status Changed 3/18/2004 10:28:01PM IT SHIFT OPS
Problem Transfer 3/18/2004 10:28:02PM IT SHIFT OPS
Add Work History 3/18/2004 10:30:04PM IT SHIFT OPS
Problem Transfer 3/19/2004 12:10:59AM IT SHIFT OPS
Add Work History 3/19/2004 12:13:20AM IT SHIFT OPS
Add Work History 3/19/2004 4:09:47AM IT SHIFT OPS
Add Work History 3/19/2004 4:10:08AM IT SHIFT OPS
Problem Transfer 3/19/2004 4:14:53AM IT SHIFT OPS
Problem Transfer 3/19/2004 8:02:43AM NTS

 

[Madawc]

In Crystal 8.5, you could do

GROUP=Previous(GROUP)

to check

Madawc Williams
East Anglia, Great Britain

 

[lbass]

Do you have the option of limiting your records to the IT SHIFT OPS group? Then you could easily use a formula like:

if datediff("h",previous({table.datetime}),{table.datetime}) > 2 then "Late Response"

-LB

 

[BlurredVision]

That would work, can that be done within a group?

 

[lbass]

Not sure what you mean. Try using a record selection formula of:

{table.field} = "IT SHIFT OPS"//substitute the correct field name

If there is an outer group, e.g., location, you would get a report by location, with records only for "IT SHIFT OPS."

Then add my earlier formula to the details section.

-LB

 

[synapsevampire]

To limit your data to just the IT Shift OPS group, use report->Edit selection formula->Record and place something like:

{table.group} = "IT SHIFT OPS"

Then LB's formula should work in the details section.

Sort of meaningless information though since you don't show any sort of ID or unique information about which problem it is, this would simply produce a report showing all problems treated as one.

Check your database, and think through your process before posting again.

You must have a Problem ID of some sort, and you would want to group on that, and then adjust LB's formula accordingly:

if datediff("h",previous({table.datetime}),{table.datetime}) > 2
and
{table.ProbIB} = previous({table.ProbID})
then "Late Response"

-k

 

[BlurredVision]

Sorry.. If I decided to group my information, say by an ID, then the previous command will pull from the group above it. Can this be stopped?

 

[BlurredVision]

My bad.. I'm lost today, way to much beer last night .. Thanks for your help

 

[synapsevampire]

Well if it's too much beer last night, then you're not only forgiven, you've also made me envious

-k