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.

[amitrathi239]

Try with below variable.Makesure table data will be sorted by Incident no and Event Date and Time.

V Show/Hide=If(RunningCount([Event]; ([Incident No])) Where ([Event]="Active")=1) Then "Show" Else "Hide"

Filter V SHow/Hide where euqal to Show