Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
Based on your description, try this:
=count({1<[Document Type]={'Instruction'}>-<Status={'Effective'},Action={'Cancel','Transfer'}>} ID)
Based on your description, try this:
=count({1<[Document Type]={'Instruction'}>-<Status={'Effective'},Action={'Cancel','Transfer'}>} ID)
Thank you so much! That worked! I knew I was probably botching my syntax.