I am looking creating a distinct feature count based on the values found in a workflow. I have a report that will compile all the unique species found. I have grouped them together so its not showing the duplicate values. However I would like to show a feature count from the species it found. I can find the total features and unique features. But I would like to see:
American Burying Beetle (1)
Finescale Dace (2)
Northern Redbelly Dace (1)
See attached pdf of what I can currently output. I tried IIF statements not they all show false values.
Iif([SCOMNAME] Like'Finescale Dace' , [DataSource.RowCount] ,False )
I have also tried the contain option.
The tech tip video shows only integer values no strings to help do the conditional statements.
Please sign in to leave a comment.