Formula to Pull Certain Value

[lesleycampbell]

I am using CR11. I have a report that is looking at Employees and Employees' Assignments.
I have the report grouped by Employee and then Assignment.
I am trying to look to create a formula that will look at the History table and pull a certain value. My formula is listed below but right now is only looking at the most recent history note. I have the formula in the Employee group footer.

This is the formula that I am currently using.

IF {History.Event} = "ACE" THEN (DATE({History.Actual_DateTime}) & " - " & {History.Event} & " - " & {History.Actual_User}) ELSE ""


Help???

Thank you!!

 

[pmax9999]

In the event there are multiple rows in the History table where {History.Event} = "ACE", I would have thought your current approach would return multiple records. Is that what is happening?

If there is more than 1 such record , what determines which one to return?

Pete

 

[lesleycampbell]

I'm really not sure how to approach that issue as of yet. Right now, it is only looking at the oldest record and if it's not an "ACE" record. So I guess I have two issues right now. Maybe I could use a maximum formula?

 

[PeteS65]

Create a formula in the details section to look at each record and store the values you need to retain in global variables for use later. If there is criteria that can be used to find a particular ACE record that could be built into the formula and could use the existing global variable values for that determination. Be sure to initialize in the report header. Values found and stored in global variables should be available in group footers.

Good luck.