AnsweredAssumed Answered

Record Count based on value list options

Question asked by bleyden on Jun 29, 2018
Latest reply on Jul 2, 2018 by philmodjunk

Hi all

Id like to have a calculated field that will show me the number of records that have a specific choice in the "Status" field.

i.e.... the status field is a dropdown of open, in process, stalled, engaged, qualified, and closed.  I'd like to return the count of all of those records that are not "closed" (hence, all records that for my purposes would be considered active).

What calculation function would be best to return this record count?

Outcomes