Quicken Community is moving to Single Sign On! Starting 1/22/21, you'll sign in to the community with your Quicken ID. For more information: http://bit.ly/CommunitySSO

Using ~ and Operators like 'AND' to filter in report

Unknown
Unknown Member
edited October 2018 in Reports (Windows)
I am trying to build some report that forces me to use the filter in the 'CONTAINS' field. I am trying to get transactions from 2 accounts into a report. But I need to filter specific transactions based on text in the MEMO field. I tried 'Memo Contains' CONTRIBUTION. it worked but it filters some wanted transactions in the other bank account.

I need to use ~ <Unwanted Keywords>. Do you know if Quicken supports - ~ <Key word 1> AND ~ <Keyword 2>. Do they support the operators like AND/OR etc. i tried AND, it didnt seem to work. Just want to check if there is a specific syntax.TIA


Comments

  • J_Mike
    J_Mike SuperUser ✭✭✭✭✭
    edited October 2018
    Unfortunately, the Quicken (Win or Mac) search feature does not support the use of logic functions - AND, OR, etc.
    QWin & QMac (Deluxe) Subscription
    Quicken user since 1991

  • Unknown
    Unknown Member
    edited October 2018
    Note in Quicken Windows it does support the ~ (Not) operator in the report Category and Memo contains fields.  But like JM said, none of the other logic operators.


This discussion has been closed.