topic Re: Set Analysis - Count specific value while excluding others in App Development

Set Analysis - Count specific value while excluding others

asdavis — Sat, 16 Nov 2024 00:30:09 GMT

In my data set I am trying to count ID (field) using a specific Document Type (field) of Instruction (value) but need to exclude any values that have a Status (field) of Effective (value) and an Action (field) of either Cancel (value) OR Transfer (value).

Currently I have the following set analysis that I am using to count a total of all documents regardless of type but with the exclusions. Where/how do I add the Document Type specifications into the set analysis?

=count({1}{-(1<Status={'Effective'}>*1<Action={'Cancel','Transfer'}>)} ID)

Re: Set Analysis - Count specific value while excluding others

GaryGiles — Tue, 02 Mar 2021 18:36:45 GMT

Based on your description, try this:

=count({1<[Document Type]={'Instruction'}>-<Status={'Effective'},Action={'Cancel','Transfer'}>} ID)

Re: Set Analysis - Count specific value while excluding others

asdavis — Tue, 02 Mar 2021 19:07:29 GMT

Thank you so much! That worked! I knew I was probably botching my syntax.