cancel
Showing results for 
Search instead for 
Did you mean: 

Formula Help

Former Member
0 Kudos

I have a report written pulling data and only showing the Top N.  My question is I need to take the number 1 option out of the list, these are always going to be the same item.  We are supporting multiple police agencies and Traffic Stop is the number 1 "nature" that is pulled (usually).  I would like the report to take 'Traffic Stop' out and show the remaining Top N which is top 10.  I have a group which then pulls a Count of cdcall.nature field.

Accepted Solutions (1)

Accepted Solutions (1)

DellSC
Active Contributor
0 Kudos

I would set the Select Expert to filter out the Traffic Stop records  before they even get to the report.

-Dell

Former Member
0 Kudos

I am not sure how to build this in Select Expert.  If I do this I am assuming it would be a formula I am building within that correct?  or maybe I am looking at it wrong.  If I do a formula I am thinking something in line of

if {cdcall.nature}='Traffic Stop' then ""

else Totext({cdcall.nature})

Or is this wrong

Former Member
0 Kudos

Figured it out.  Thanks for the direction.

Answers (0)