Nested if statements

[former_member947657]

I will try my best to explain what I need. A sample of my data is below and I need to only see Incident No where the Event Detail "Active" occurs before anything else.

So, if the incident numbers match and the first event to happen is "Active" then show that incident number and hide all others.

Appreciate any help.

[ayman_salem]

1- Define the following formulas:

v_minDate: =Min([Event Date And Time]) In ([Incident No])

v_status_1: =If ([Event Date And Time] = [v_minDate] ForEach ([Incident No]) And ([Event] = "Active")) Then "1"

v_status: =Count([v_status_1]) In ([Incident No])

2- apply filter on Table [v_status] Equal to 1

...

I hope it will help